Hello,

I am looking for a way to capture info from one column while referring it to
another. For example, the info I'm analyzing pertains to cities and the
provinces in which they're located. I'd like to find a way in which I can
capture instances in which multiple cells in Column A refer to one cell in
Column B. (i.e. Ottawa and Toronto are both located in Ontario) I've tried
a SUMPRODUCT formula, but it won't let me put multiple instances in the same
calculation. Is there something else I can try?

This is what I'm currently trying, but unable to make work:
=SUMPRODUCT(--(Calculations!$M$2:M$3935="Ottawa","Toronto"),--(Calculations!$I$2:I$3935="Ontario"))

When I try it with simply "Ottawa" it works, but when I try to add another
city, an error appears.

This is an example of the data I have:

Column A
Hafford
Ottawa
Toronto
Montreal

Column B

Saskatchewan
Ontario
Quebec


Thanx!
Srain