sumif question

[iceeagle]

I am trying to add cells over a number of cols based on infromation in the first col a
i.e

col a col b col c col d
printer 16 17.5 23
printer 12 13 5
gluer 30 12 25
stripper 19 13 14
printer 12 14 6
gluer 32 18 15

I have tried sumif but only get a total for col b . I need to get the totals for printer/gluer/stripper over cols b to col d. Any help would be really appreciated.

 

[Yusuf]

Hi

Have you tried a pivot table? It would give you summaries of each column for each title.

 

[AlphaFrog]

Excel Workbook
	A	B	C	D	E	F	G
1	printer	16	17.5	23		printer	118.5
2	printer	12	13	5		gluer	132
3	gluer	30	12	25		stripper	46
4	stripper	19	13	14
5	printer	12	14	6
6	gluer	32	18	15
Sheet

 

[Aladin Akyurek]

I am trying to add cells over a number of cols based on infromation in the first col a
i.e

col a col b col c col d
printer 16 17.5 23
printer 12 13 5
gluer 30 12 25
stripper 19 13 14
printer 12 14 6
gluer 32 18 15

I have tried sumif but only get a total for col b . I need to get the totals for printer/gluer/stripper over cols b to col d. Any help would be really appreciated.

Also...

Control+shift+enter, not just enter:

=SUM(IF($A$2:$A$7=F2,$B$2:$D$7))

where F2 houses a condition like printer.

 

[T. Valko]

I am trying to add cells over a number of cols based on infromation in the first col a
i.e

col a col b col c col d
printer 16 17.5 23
printer 12 13 5
gluer 30 12 25
stripper 19 13 14
printer 12 14 6
gluer 32 18 15

I have tried sumif but only get a total for col b . I need to get the totals for printer/gluer/stripper over cols b to col d. Any help would be really appreciated.

Try this...

Book1
	A	B	C	D
2	printer	16	17.5	23
3	printer	12	13	5
4	gluer	30	12	25
5	stripper	19	13	14
6	printer	12	14	6
7	gluer	32	18	15
8	_	_	_	_
9	printer	118.5	_	_
Sheet2

Formula entered in B9:

=SUMPRODUCT((A2:A7=A9)*B2:D7)

 

[iceeagle]

Many thanks for all the replies - problem now solved, thanks again everyone.

 

[T. Valko]

Many thanks for all the replies - problem now solved, thanks again everyone.

You're welcome. Thanks for the feedback!

 

[Aladin Akyurek]

Many thanks for all the replies - problem now solved, thanks again everyone.

That's great. Thanks for providing feedback.