Forum Discussion
Help with SUM Function
Hi, I hope I get some help here in the forum. Here is my problem: I have a workbook with several sheets, named with numbers from 1 to 31 representing the days of a month. I've to do a formula whe...
Hi Lorenzo,
I bit compacted your formula
=SUM('5:8'!C9)
but didn't catch how you suggest to make it dynamic, did I miss something?
Yes, INDIRECT won't work since it shall return value from referenced cell, not the case here.
Mr. Baklan
the compacted formula is neat!
the query is from Mr. Reyes - I am just recommending some sort of work around.
honestly I did not absorb fully his problem.
maybe you can help him.
Thank you..
the compacted formula is neat!
the query is from Mr. Reyes - I am just recommending some sort of work around.
honestly I did not absorb fully his problem.
maybe you can help him.
Thank you..