Summary Tab after filters

Occasional Visitor

I have a master cost template tab, with multiple cost codes and drop down criteria for multiple scenarios. is there a way to create a summary budget tab which combines the total cost per cost code? hard to explain the scenario, see attached screen shot which hopefully depicts what I'm after. TIA.

1 Reply

Hi @adamjjbailey 

 

if you really need to work with formulas, here is one solution.

Create a helper column in your master sheet (lets call it "visible?"). Put the following formula in this column:

=(AGGREGATE(3;5;A2)>0)+0

The formula checks if the cell in A2 is visible (1) or not (0)

On your summary sheet, you can now use the SUMIFS formula to sum up all the visible amounts for a specific cost center.

 

Here is an example:

FilteredSumifs1.png

After using a filter in column B, it looks like this:

FilteredSumifs2.png