SUM- multiple conditions with text

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
 
J

Jason Morin

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
 
L

lunker55

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...
 
L

lunker55

I think I got it. There was a "-" in one of the rows.
Seems to work now.
Thanks Jason

Joe
 
L

lunker55

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

can I define validation range by function? 1
nesting sumproduct with subtotal 9
Referencing a range name as part of a formula\ 0
SUMIF with multiple columns in sum range 3
Help Writing a SUM Formula 5
multiple if conditions - use sumif/sumProduct? 5
Data Validation, Dynamic Named Ranges, and Dependant Lists 0
Sum with multiple conditions and wildcard 2

Top