Sum Based On Criteria

[kme]

Kindly Create Formula Based On The Criteria. Based On Selection Result Fully Automate.

1. In 2nd Sheet (Wrok Sheet ) Different Branches Sales Data Are Given .
2.From Worksheet We Need Automatically Sort Out Through Formula Brand Wise Data , As per the Selection Through Dropdown list Criterias.
3.Drop Down List and Sample Report Format are Given In 1st Sheet ( Brand Wise ) .
4. 1St-Criteria Brand, 2nd- Criteria- Branch, 3rd Criteria-Division,4th- Criteria- Sales/Profit/Profit%.
5.While Selecting Drop Down List "ALL" Then Return That Criteria Under all Things items Result.
6.First 3 Drop Down List "Added "ALL" Options. If "ALL" Select that Criteria All Division Result Came.
7.If any of The Drop Down List Select "ALL". Then Result Came That Drop down list items Full result. If Select From 3 Drop Down list "ALL" . Then Full Report Result came.
8.Branch Code Put Instead Of Branch Name . Branch Code Details In Brand Wise Sheet Colum "AA"
11.From Column E11 to Below Brand Name Should Came . If In Brand Drop Down List "AL" Select. All Brand Name Should Came From Column E11 to Below
12.Based On the Brand Name Should Came The Value Result.
13.Wrok Sheet Data From January-2024 to Sep-2024 .Result Came to Report Month Wise.

 

[p45cal]

Why re-invent the wheel?

 

[kme]

Can Let a Excel Formula While Selection From Drop Down List "ALL" Option Then return value Full Value came.

 

[p45cal]

Can Let a Excel Formula While Selection From Drop Down List "ALL" Option Then return value Full Value came.

I don't understand the above sentence!
The equivalent for ALL in the slicers is the red cross (which means no filtering):