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
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