Better formula

[B.B]

Looking for a short cut for this formula. I need to repeat this for ever 5th
pair of rows up to row 81.
=SUMIF(C10,"he",E10)+SUMIF(C11,"he",E11)+SUMIF(C15,"he",E15)+ ......
Any way to make this quicker formula so I am not making a insanely long
formula?

 

[Max]

One guess ...
Try: =SUMPRODUCT((C10:C81="he")*(OR(MOD(ROW(E10:E81),5)={0;1})),E10:E81)

 

[Biff]

Try this:

=SUMPRODUCT(--(MOD(ROW(C10:C81),5)<2),--(C10:C81="he"),E10:E81)

Biff