Doshka,
You need to be more specific about how your data is setup (e.g. each row is
a separate entry, Column A will signify if there are 6 states, and Columns
B:? contains the states) before anyone can truly help you. If the
spreadsheet is setup as explained before (i.e. Column A signifies the answer
and Colunns B:? contain the states), then you can simply use a COUNTA formula
in column A. So, if B1 = "Utah", C1 = "Nebraska", D1 = "New Mexico", E1 =
"Washington", F1 = "Nevada", G1 = "New York", and H1 = "Ohio", then you can
insert the following formula into A1: =IF(COUNTA(B1:H1)>6, "6 or More
States","")
Best,
Matthew Herbert
