i want to use the value in two fields to generate a sum statement like the following. AE55 contains the start row and af55 contains the last row. the sum statement should read sum(g53:g55).
=IF(AE55>0,SUM("G",INDIRECT(AE55),":G",INDIRECT(AF55),")"," "))
Solved by T. H. in 25 mins