Forum Discussion
Solved
Column totals, with exceptions and equal to current/next month
Hi I have tried SUMIFS and SUMPRODUCTS but still cannot get this to work, and have tried MS community. I have a report that contains annual finance data and i am trying to produce a dashboard. I h...
See if the attached workbook gets you started. Note that the months are all real dates.
The second sheet cannot use tables, for tables do not allow dynamic array formulas.
Hi - yes thank you.
The codes are assigned to activites carried out, there are about 25 or so in total. but 6 of those (9.1) being one of them arent activities that need to be calculated and must be excluded from the sum to give an accurate figure for forecast (they also have to be excluded for monthly spend too, but i have written that formula already, but that foruma doesnt need to move one month to the next)
The codes are assigned to activites carried out, there are about 25 or so in total. but 6 of those (9.1) being one of them arent activities that need to be calculated and must be excluded from the sum to give an accurate figure for forecast (they also have to be excluded for monthly spend too, but i have written that formula already, but that foruma doesnt need to move one month to the next)
See if the attached workbook gets you started. Note that the months are all real dates.
The second sheet cannot use tables, for tables do not allow dynamic array formulas.
Hi Hans
HansVogelaar - thank you very much for this, it worked. It was way above what i could conjour up myself.
I really appreciate the help.
Have a great weekend