bobgrand
Board Regular
- Joined
- Apr 14, 2008
- Messages
- 244
- Office Version
- 365
- Platform
- Windows
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?
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?