Summing Certain cells

  • Thread starter Thread starter Alex
  • Start date Start date
A

Alex

I am adding certain water diversions in a listing.
For example:
worksheet
A B C D
1 Year ID Jun Jul Aug
2 2001 5903 18 21 34
3 2001 5904 19 40 10
4 2001 5906 17 21 39
5 2001 5915 12 24 24
6
7
8
9 Tomichi to Cebola
10 5903 5906
11 =SUMIF(a10:b10=$b$2:$b$5,b2:b5)

My sumif function does not work. Perhaps I need to make
an index function. I don't know and need some help.

Please assist me.

Thank you.
Alex
 
What are you trying to sum? The data for each month for
5903 and 5906? If so, here's an example for June:

=SUMPRODUCT(((B2:B5=A10)+(B2:B5=B10))*C2:C5)

HTH
Jason
Atlanta, GA
 
I want to sum the monthly values
In the example,
For June, 18 and 17
For July, 21 and 21
For Aug, 34 and 39

Note: my list of IDs is much larger and the IDs to sum
also is not constant in number.
 
I get a #VALUE! error. Does anyone
know how to get the same result with an
index, sumif, or other function combo?
 
Back
Top