Formulas for Dashboard # 2

[Freeman2022]

I’m in the process of making a dashboard..

I would like to calculate the total cases by Year and by Customer Name

I will use combo boxes for both.

I’m having trouble with the formulas because of the “ALL” Years and “ALL” Customers.

What Formulas would go in Columns J and M?

Also would like it to work if I only select 2019 with Customer C

 

[Fluff]

Duplicate to: Formulas for Dashboard to calculate "ALL"

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread.