using sumif to sum multiple columns??

jinx_uk_98

Board Regular
Joined
Jul 3, 2005
Messages
105
Hi all,

I need some more words of wisdom please.

I'm using this formula to sumif 4 columns (K,L,M & O).

=SUMIF('Daily Info'!D7:D400, O3,'Daily Info'!K7:K400)+SUMIF('Daily Info'!D7:D400, O3,'Daily Info'!L7:L400)+SUMIF('Daily Info'!D7:D400, O3,'Daily Info'!M7:M400)+SUMIF('Daily Info'!D7:D400, O3,'Daily Info'!N7:N400)

as you can see I'm just copying =SUMIF('Daily Info'!D7:D400, O3,'Daily Info'!K7:K400) and adjusting the sum columns and adding them together.

Is there an eaiser way to do this? My range of columns is K7:ZA400.

Many thanks
Kev
 

Some videos you may like

Excel Facts

How to create a cell-sized chart?
Tiny charts, called Sparklines, were added to Excel 2010. Look for Sparklines on the Insert tab.

just_jon

Legend
Joined
Sep 3, 2002
Messages
10,473
jinx_uk_98 said:
Hi all,

I need some more words of wisdom please.

I'm using this formula to sumif 4 columns (K,L,M & O).

=SUMIF('Daily Info'!D7:D400, O3,'Daily Info'!K7:K400)+SUMIF('Daily Info'!D7:D400, O3,'Daily Info'!L7:L400)+SUMIF('Daily Info'!D7:D400, O3,'Daily Info'!M7:M400)+SUMIF('Daily Info'!D7:D400, O3,'Daily Info'!N7:N400)

as you can see I'm just copying =SUMIF('Daily Info'!D7:D400, O3,'Daily Info'!K7:K400) and adjusting the sum columns and adding them together.

Is there an eaiser way to do this? My range of columns is K7:ZA400.

Many thanks
Kev

Big range, but try

=SUMPRODUCT((D7:D400=O3)*(K7:ZA400))
 

Aladin Akyurek

MrExcel MVP
Joined
Feb 14, 2002
Messages
85,201
jinx_uk_98 said:
Hi all,

I need some more words of wisdom please.

I'm using this formula to sumif 4 columns (K,L,M & O).

=SUMIF('Daily Info'!D7:D400, O3,'Daily Info'!K7:K400)+SUMIF('Daily Info'!D7:D400, O3,'Daily Info'!L7:L400)+SUMIF('Daily Info'!D7:D400, O3,'Daily Info'!M7:M400)+SUMIF('Daily Info'!D7:D400, O3,'Daily Info'!N7:N400)

as you can see I'm just copying =SUMIF('Daily Info'!D7:D400, O3,'Daily Info'!K7:K400) and adjusting the sum columns and adding them together.

Is there an eaiser way to do this? My range of columns is K7:ZA400.

Many thanks
Kev

In ZB7 on Daily Info enter & copy down:

=SUM(L7:O7)

Then invoke:

=SUMIF('Daily Info'!$D$7:$D$400, O3,'Daily Info'!$ZB$7:$ZB$400)
 

Watch MrExcel Video

Forum statistics

Threads
1,118,680
Messages
5,573,624
Members
412,539
Latest member
itchy00
Top