sumif function or something else needed?

K

kathy

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..
 
D

Don Guillett

Did you make your ranges ABSOLUTE

=Sumif($E$2:$E$43,"Dawson Creek",$J$2:$J$43--

Don Guillett
Microsoft MVP Excel
SalesAid Software
(e-mail address removed)
 
K

kathy

yes I tried that... here is a glichy thing.. played with this last nite
again.. I had put the formula in after setting up the spreadsheet.. formula
did not work.. finally I emptied column E of all information.. set up the
formula then did the column E input.. finally it worked.. but only that way..
just for spite tried to set it up again with column E filled in before
formula.. would not work... anyone else find this?
 
D

Don Guillett

If desired, send your file to my address below along with this msg and
a clear explanation of what you want and before/after examples.
 
Top