Forum Discussion
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...
Hi, 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.
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.
- Thanks 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.
=SUMIFS(sales_column, month_column, specific_month, product_column, IF(specific_product="All Products", "*", specific_product))