ImokatExcel,

Your your formulas work perfect and I get what I need ONLY IF I know the H column's names. However, I don't know names in the H columns.... I put them there as an example.

All I know is the table B5:E22.

I need to look up names that satisfy the criteria in B5:E22 table, than include the name and corresponding difference for NY, NJ, CT (as you did with your SumIfs formula).

Please advise if you have an idea!


Thanks!