SUM Range more than one column - SUMIF

Thanks:  0
Likes:  0

# Thread: SUM Range more than one column - SUMIF

1. ## SUM Range more than one column - SUMIF

Hi,

How would I SUM all the results from results 1-5 if say ITEM in column A = C?

SUMIF wont work as it only sums the first column...

 A B C D E F 1 ITEM RESULT 1 RESULT 2 RESULT 3 RESULT 4 RESULT 5 2 A 1 2 2 77 2 3 B 10 7 5 5 5 4 C 2 1 77 2 5 A 10 10 33 7 6 A 5 2 33 5 7 B 1 33 7 8 C 7 1 2 9 C 5 5 5 10 B 7 2 7 7 2

2. ## Re: SUM Range more than one column - SUMIF

Try...

=SUM(IF(A2:A10="C",B2:F10))

...confirmed with CONTROL+SHIFT+ENTER.

3. ## Re: SUM Range more than one column - SUMIF

try

=SUMPRODUCT((A2:A10="A")*B2:F10)

or

=SUM(IF(A2:A10="A",B2:F10))

with CSE

4. ## Re: SUM Range more than one column - SUMIF

Try this:

=SUMPRODUCT((A2:A10="A")*B2:F10)

5. ## Re: SUM Range more than one column - SUMIF

Originally Posted by Domenic
Try...

=SUM(IF(A2:A10="C",B2:F10))

...confirmed with CONTROL+SHIFT+ENTER.
Of course - thank you.

Excuse my brain freeze. I guess I was trying to tackle it with a sledge hammer when a simple tap with a hammer did the trick.

Thanks

And BTW, your website is GREAT. Really handy and easy to uderstand solutions. Well done.

6. ## Re: SUM Range more than one column - SUMIF

Thanks sanrv1f & #NAME?

My bad habit with SUMPRODUCT of using , at the end rather than *

Thanks for the reminder and solution

7. ## Re: SUM Range more than one column - SUMIF

Originally Posted by shemayisroel
Of course - thank you.
You're very welcome!

And BTW, your website is GREAT. Really handy and easy to uderstand solutions. Well done.
Thank you, shemayisroel! I really appreciate it!

8. ## Re: SUM Range more than one column - SUMIF

Does anyone know how to sum multiple coloumns with multiple conditions? Should I use sumif or sumproduct function?

9. ## Re: SUM Range more than one column - SUMIF

Originally Posted by Acon
Does anyone know how to sum multiple coloumns with multiple conditions? Should I use sumif or sumproduct function?
It really depends on your actual requirements. I'm on my way out, so I would suggest that you start a new thread and provide an example of the data, describe what you'd like to do, and provide the actual results based on your sample data.

10. ## Re: SUM Range more than one column - SUMIF

Originally Posted by Domenic
It really depends on your actual requirements. I'm on my way out, so I would suggest that you start a new thread and provide an example of the data, describe what you'd like to do, and provide the actual results based on your sample data.
I Tried that array sum if formula, however it keeps generating " excel running out of resources, formula cant be calculated" error message!
my pc has 16 GB ram and I7 processor, shouldn't be an issue to do a simple sum if I guess.

what am I doing wrong?

## User Tag List

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•