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...
Mr. Reyes
attached is a sample file for you to determine if it answers your query.
HTH
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..