View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
PCLIVE PCLIVE is offline
external usenet poster
 
Posts: 1,311
Default 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