SUM- multiple conditions with text

  • Thread starter Thread starter lunker55
  • Start date Start date
L

lunker55

IF RANGEA="m" and RANGEB="Dave", then SUM RANGEC

I think it is a nested sum, but I can't figure it out!
Any help would be greatly appreciated.
I am getting confused between SUM and SUMIF nested formulas.


RANGEA, RANGEB, RANGEC are just named ranges.

I tried: {=SUM((RANGEA="m")*(RANGEB="Dave")*RANGEC)}

And: {=SUM((RANGEA="m")*IF((RANGEB="Dave"),1)*RANGEC)}

Joe
 
Your first array formula looks fine to me. What error are
you getting? I'd check to make sure all my cells contain
numbers in RANGEC. I'd also ensure that all your named
ranges are of the same dimension (rows x columns).

HTH
Jason
Atlanta, GA
 
I am getting #VALUE! error

Joe


Jason Morin said:
Your first array formula looks fine to me. What error are
you getting? I'd check to make sure all my cells contain
numbers in RANGEC. I'd also ensure that all your named
ranges are of the same dimension (rows x columns).

HTH
Jason
Atlanta, GA
Click to expand...
 
I think I got it. There was a "-" in one of the rows.
Seems to work now.
Thanks Jason

Joe
 
I got the first one going. I had a problem with the second one, but fixed
it. I think there was a blank space in one of the fields that was causing
the same problem.

Joe
 
Back
Top