View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
bethg7 bethg7 is offline
external usenet poster
 
Posts: 8
Default 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??