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.
Can you provide an example of the desired result?
Hi Yes sorry i meant to do that.
Image attached.
The top table is current month
The bottom is next month
Column C is the forecast for each, and
Column B is the options (column A is hidden for sensitivity but is not used for anything other than completeness in these tables.
The titles of In month and next month are and =TODAY() displayed a month rather than date.
Cells B1, 2, 14, 15 - are me typing those to try and use them as a reference for the formula (when 1:1 from the report matches that month count that column for each option, and exclude certain tasks)
When the month then moves onto the next then id like it to automatically move on. as the report contains this financial years data. thanks
Thanks. You mentioned "the task codes also have 6 in total that i do not want to calculate". Can you elaborate?
- 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)
