using a variable for MOD Statement
I make a report that has a varying number of rows and I use the variable
"MaxNumRows". The totals line for the report = MaxNumRows +3. Works great
so far!
I am using the cod
=SUM(IF(MOD(ROW(R3C12:R(MaxNumRows)C12)-ROW(R3C12)+1,3)=0,R3C12:R(MaxNumRows)C12,0))
Doesn't work! I use MaxNumRows in other formulas; but it isn't working in
THIS one. How can I make this formula become ...ROW(R3C12:R20C12) if the
MaxNumRows = 20??
|