Forum Discussion
fran-d-31250
Apr 05, 2023Copper Contributor
Need help with formula for combining SUMIFS with IF from a dropdown list
I am building a sales dashboard that summarises sales by month and by product. I have SUMIFS functions that sum all product sales based on month which works fine. I am now trying to incorporate a dro...
HansVogelaar
Apr 05, 2023MVP
The SUMIFS function lets you specify more than one condition.
- fran-d-31250Apr 05, 2023Copper ContributorHi, sorry my mistake - I am using SUMIFS already to sum the sales based on month. I then need to add in a formula that includes the dropdown box as an argument in the function. Using SUMIFS isn't working for this as there are too many arguments.
- HansVogelaarApr 05, 2023MVP
You should be able to use a formula like
=SUMIFS(sales_column, month_column, specific_month, product_column, specific_product)
where specific_product is the cell with the product drop-down.
- fran-d-31250Apr 05, 2023Copper ContributorThanks Hans - I can get that far with it, but the third option for All Products needs to be a sum of Product A and Product B. Therefore Product A needs to somehow be both Product A and All Products, and Product B needs to be Product B and All Products.