SUM Range more than one column - SUMIF

[shemayisroel]

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

[Domenic]

Try...

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

...confirmed with CONTROL+SHIFT+ENTER.

[sanrv1f]

try

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

or

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

with CSE

[T. Valko]

Try this:

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

[shemayisroel]

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.

[shemayisroel]

Thanks sanrv1f & #NAME?

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

Thanks for the reminder and solution

[Domenic]

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!

[Acon]

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

[Domenic]

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.