View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
markus markus is offline
external usenet poster
 
Posts: 20
Default SUMIF every 2nd cell

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