Phylis Sophical
New Member
- Joined
- Jan 13, 2002
- Messages
- 42
This is somewhat the same problem I had with a zero value in the divide cell. I am adding up every other cell, then dividing it by a total of several other non consecutive cells. This is my formula so far:
=SUM(B4,B12,B20,B28,B36,B44)/SUM(B9,B17,B25,B33,B41,B49)
I want to do something like what you showed me before with the =IF(A1=0,0,(rest of formula.
Do I have to do the =IF and then list every one of these cells or is there a shorter way?
This message was edited by Phylis Sophical on 2002-04-16 23:14
=SUM(B4,B12,B20,B28,B36,B44)/SUM(B9,B17,B25,B33,B41,B49)
I want to do something like what you showed me before with the =IF(A1=0,0,(rest of formula.
Do I have to do the =IF and then list every one of these cells or is there a shorter way?
This message was edited by Phylis Sophical on 2002-04-16 23:14