Summing Certain cells

[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

 

[Frank Kabel]

Hi Alex
what values do you want to sum in your example?

 

[Jason Morin]

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

 

[Alex]

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.

 

[Frank Kabel]

Hi
for June use something like
=SUMPRODUCT(--(B2:B5=A10:B10),C2:C5)

 

[Alex]

I get a #VALUE! error. Does anyone
know how to get the same result with an
index, sumif, or other function combo?

 

[Frank Kabel]

Hi
sorry, my fault. Try
=SUMPRODUCT((B2:B5=A10:B10)*(C2:C5))