SUMIF every 2nd cell
If "601" really is text, then:
=IF(AND(E5="601",G5="601",I5="601",K5="601"),SUM(D 5,F5,H5,J5))
But if it is a number, then:
=IF(SUM(E5,G5,I5,K5)=2404,SUM(D5,F5,H5,J5))
You'll need to address if the result is False. Right now this formula just
returns False.
HTH,
Paul
"Markus" wrote in message
...
Hi,
I hope someone can give me a hand here.
I have the following:
D E F G H I J K
5 10 601 8 601 3 614 4 601
I want to program a cell that will add up D5, F5, H5, J5 only if text in
E5,
G5, I5 and K5 is "601", so that my result should be 22
Thanks for your assistance
Markus
|