I am asking some formula for electrical panel schedule

[james64]

Hi everybody



I would like to ask a question.

I am working on electrical panel schedule using excel formula, but it looks like spending a lot of time tediously. So I am asking your comment how to apply some formula every other three number summation. Please see attached file for your reference. For example, I am adding sum(F12+F15+F18+..F42).

Many thanks in advance.

James

[xor]

=sumproduct(--(mod(row($f$12:$f$42),3)=0),$f$12:$f$42)

[james64]

Hi XOR,

I appreciate your answer. It works well for my application.

Many thanks again