#DIV/0! - Brain Fart

[bobgrand]

Hello all,

Hope someone can help me with this.

Col A = Number of Months
Col C thru Z = Number of pcs per month

I need to sum C thru Z and divide by A.

Some rows have zeros across the board. 0 in A and 0's in C thru Z.

I am having trouble returning a zero if the sum of C thru Z = 0 and Number of Months = 0

I think this explains it all.

Any help would be greatly appreciated.

Bob?

 

[petertenthije]

=if(or(A2=0,sum(C2:Z2)=0),0,sum(C2:Z2)/A2)

 

[bobgrand]

Peter, Thank you, I just saw from the formula you posted what I was doing wrong.

Thanks again