Forum Discussion
Auto filling fields and calculations
Here's my problem. I have a poker spreadsheet for let's say 30 people. Spreadsheet shows how each person finished each month and the points awarded for each month and then automatically adds up eac...
RedIce ,
That could be
=IFERROR(
SUMPRODUCT($B2:$Y2*(MOD(COLUMN($B$2:$Y$2),2)=1))-
SUM(AGGREGATE(15,6,1/(MOD(COLUMN($B$2:$Y$2),2)=1)/(LEN($B2:$Y2)>0)*$B2:$Y2,{1,2}))
,0)
It ignores blank cells but takes into account cells with 0, and return zero if you have only one result.