Marvin, thanks for the help. What I sent was just a detail from a 5-page report, so a pivot table won't work in this case unfortunately. What I can't understand in the file you sent was why the formula generating the "43" works for Northeast, but when I key in Northwest, I get a FALSE. It seems to be taking the first instance of two variables but not matching all three. Do you see what I mean?