G
GerryK
Hi,
I have a formula (deeply in debt to this Newsgroup for
this) that, flawlessly, looks at certain last entries in a
row and returns a required value in a separate cell. The
synatx is:
=SUMPRODUCT((MOD(COLUMN(SETV(OFFSET(C1,,COUNT(C1:IV1)-
6,,6)))-CELL("Col",GETV())+0,2)=0)*(GETV()))/3
If a zero, or formula that returns zero, exists in that
row, the calculation is compromised.
I would like to allow a simple SUM(R2:R10) for example, to
reside in the blank cells to the right of the last numeric
entry in the row by modifying the above formula to ignore
the zero (or inserted formula=0) when the column and total
is empty. I do not know how to accomplish this! Can anyone
please help.
TIA
Gerry
I have a formula (deeply in debt to this Newsgroup for
this) that, flawlessly, looks at certain last entries in a
row and returns a required value in a separate cell. The
synatx is:
=SUMPRODUCT((MOD(COLUMN(SETV(OFFSET(C1,,COUNT(C1:IV1)-
6,,6)))-CELL("Col",GETV())+0,2)=0)*(GETV()))/3
If a zero, or formula that returns zero, exists in that
row, the calculation is compromised.
I would like to allow a simple SUM(R2:R10) for example, to
reside in the blank cells to the right of the last numeric
entry in the row by modifying the above formula to ignore
the zero (or inserted formula=0) when the column and total
is empty. I do not know how to accomplish this! Can anyone
please help.
TIA
Gerry