Sum according to cell info

  • Thread starter Thread starter Ed Davis
  • Start date Start date
E

Ed Davis

I want to sum three column of numbers according to a category number that
lies in three columns,
The category numbers are in columns B5 - B61 and then starting at N5 - N61
and then again starting at Z5 - Z24.
The category numbers are 1 - 6. But may add categories later.
I would like the sums to go into cells AH32 - AH37.
 
I am sorry I forgot to mention where the data is I am looking for.
F5 - F61
R5 - R61
AD5 - AD24
 
Try this:

AG2:AG7 = 1,2,3,4,5,6

=SUMIF(B$5:B$61,AG2,F$5:F$61)+SUMIF(N$5:N$61,AG2,R$5:R$61)+SUMIF(Z$5:Z$24,AG2,AD$5:AD$24)

Copy down to AH37

--
Biff
Microsoft Excel MVP


Ed Davis said:
I am sorry I forgot to mention where the data is I am looking for.
F5 - F61
R5 - R61
AD5 - AD24
Click to expand...
 
Thank you that worked great.


--
Thank You in Advance
Ed Davis
T. Valko said:
Try this:

AG2:AG7 = 1,2,3,4,5,6

=SUMIF(B$5:B$61,AG2,F$5:F$61)+SUMIF(N$5:N$61,AG2,R$5:R$61)+SUMIF(Z$5:Z$24,AG2,AD$5:AD$24)

Copy down to AH37
Click to expand...
 
Back
Top