I understand that Excel has a function to sum only the visible columns, but it does not appear that this excludes columns hidden by JET. What is the best way to sum the visible columns in a JET Report when some some columns with data have been hidden?
Date
Votes
2 comments
-
Jet Reports Historic Posts Official comment Hmmm, I guess the answer depends on the structure of your report. You could just use a SUMIF function and use Row 1 (or Row 2 if you are doing conditional hide) as the range, "<>Hide" as the criteria and then whatever you want to sum as the sum_range. Does that work for you?
Regards,
Hughes -
Jet Reports Historic Posts Sorry for the delay in responding. Your advise on =SumIf( works great! Thanks!!!
Please sign in to leave a comment.