Hello,
I have the a formula below that I'm trying to 'dynamically' sum the column of the months based on a criteria.
I checked via the evaluate formula, and I can see that my 'sum_range' is taking from the column that I want, i.e. result is Sheet1!$S:$Z.Please Login or Register to view this content.
But it's giving me a #VALUE! error.
So what is wrong in my above formula?
If I'm not using the correct formula, what would be the correct formula that sums up multiple columns (i.e. from Jan to Aug, or Apr to Jun etc) given a criteria(s)
Thanks!
Bookmarks