I have column E2 to E43 with place names e.g Dawson Creek, Peace River,
GrandePrairie and I want the corresponding numbers in column J2 to J43 1196,
990,946 to sum in cell K49 .. as in if I have 10 dawson creek entries I want
the total in K 49 to be 11960 in K50 10 Peace Rver entries to total 9900..
and 10 Grande Prairie entries to total 9460 in K51.. I have put in
=Sumif(E2:E43,"Dawson Creek",J2:J43)in K49 and it works but same does not
work for K50 and K51 with just changing the Name to Peace River and Grande
Prairie respectively... please help..