Didn't think I would have this many problems with this....
Column A has all of the state abbreviations.
Column B has values.
450 rows of data; some states show up multiple times.
Want to generate an If statement that says,
"If the value in column A = "TX", take the corresponding value in column B. Sum all those values together for a total value for Texas."
Generating the If for one state cell and one value cell is easy;
If(A1="TX",B1, 0)
When I expand the search parameters to include the entire list of state abbreviations, it dings me with the dreaded #VALUE.
Thanks, all
TJ
Column A has all of the state abbreviations.
Column B has values.
450 rows of data; some states show up multiple times.
Want to generate an If statement that says,
"If the value in column A = "TX", take the corresponding value in column B. Sum all those values together for a total value for Texas."
Generating the If for one state cell and one value cell is easy;
If(A1="TX",B1, 0)
When I expand the search parameters to include the entire list of state abbreviations, it dings me with the dreaded #VALUE.
Thanks, all
TJ