I assume a VLOOKUP is what you're looking for. I would try this in the cell
you would like to return the data:

=VLOOKUP("NY",A3:B5,2,FALSE)
with
"NY" being the state you would like to look up (you can reference another
cell here if you like)
"A3:B5" being the range of states and numeric values in columns A and B
2 being the column you would like returned in the range

Hope this helps. Reply back if you need further info or if this is way off.

-Chad


"TrevorC" wrote:

I have two columns, Column A with States listed (i.e. FL, NY, AB) and Column
B with a numeric value. I need to know how many people live in NY that have
a value in Column B greater than zero.
Can anyone help?
Thanks.
coffeyt