In the attached file I have successfully written formulas in row 19 using sumif & sumproduct that will display the total budget (calculated from column L) when filtered. In columns M & N, it accurately gives me the budget total of projects that have any mark in those columns).
For example, when I filter on company 0006 (column B), it shows that of the total project budget of $1,116,000, $250,000 were closed, and $29,000 had a date change.
My next challenge has stumped me though. I want to write formulas for cells M21-N26 that will give me those numbers by company, WITHOUT filtering the file. In otherwords, I want the company subtotal/results to be visible at all times, whether the file is filtered or not. I know it will need to look at both the contents of column B & either column M or N, and return the sum of column L, but I don't know how to write the formulas. Please help me
Thanks in advance!
(BTW, I have inserted L29-N34 manually. By filtering the file by company, I know that these are the values that should be the result of the formula I'm searching for).
Bookmarks