Conditional Sum

  • Thread starter Thread starter Jay
  • Start date Start date
J

Jay

Hello,

I am having trouble setting up several conditional sums.
Here is an example of how my cells are set up.

A1 = Groups, B1 = Received, C1 = Lost
A2 = Care 1, A3 = Care 2, A4 = BDM

To fill in the columns of Received & Lost, any # values
can be used.

I need to know how to sum the received values for groups
Care 1 & Care 2.

My real report has many 'groups'. Which some of those
groups are to be tied up into other groups.

Also, some extra information is that the row & column
labels do contain up to 3 words, and the series range or
rows & columns does not start at A1. I don't know if
you'd need to know that, but that may create a problem?
I'm not sure.

But I'd greatly appreciate any help with this.

If you would like the actual file I am dealing with,
please let me know I will e-mail it to you. I know my
example above is pretty confuseing.

Thanks,
Jay Gustafson
 
Hi Jay,

try,

=SUMPRODUCT((A2:A10="Care 1")+(A2:A10="Care 2"),B2:B10)

Hope this helps!
 
Back
Top