using sumif to sum multiple columns??

[jinx_uk_98]

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

 

[just_jon]

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]

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)

 

[just_jon]

Now why didn't I suggest that...