Hi All,
Apologies if this causes any repetition, but I've looked at a number of threads around this topic and im struggling to find an answer that does exactly what im looking for here.
I am trying to create a dynamic subtotal table at the top of a spreadsheet that counts the number of instances of given scenarios (from a big data dump below the table - Rows 18-71), where there are numerous IFs required to be met across different columns that play into the scenarios...
e.g. I have 'Outlet Type' in Column A, & i have 'Outlet Open Status' in Column C - as well as many other fields around them in other columns like 'who owns the outlet', 'Outlet quality' or 'does it have outdoor space'' etc.
What i want to be able to do is have the subtotal count the number of outlets that are say Open (e.g. Green), by Type (e.g. 09. Restaurant), when i then filter on other columns like 'Outlet Owner' in Column D or on Outlets that have 'Outside Seating' in Column E.
That way, it is possible to regularly paste in the data dump, and have users see how many scenarios there are of different types over time, to help with planning.
BUT, i cant seem to get the subtotal to give me a count other than ZERO, when there are two conditions in DIFFERENT COLUMNS.
I want the area highlighted in Yellow on the example spreadsheet to subtotal the count of scenarios, when you filter on a column in row 18
Could anyone help?
Bookmarks