Hi, I have a question, if i have columns that already have drop down lists-for example one that says "colors" and one that says "shapes". Am i able put a sum table where if i choose for example "blue" and square" and it automatically sums up those choices? Thank you!
Yes you could. One way is you could add an IF statement and nest your SUMIF in the false section of your if statement =IF(A1="All",sum(qtycolumn),SUMIF()). Assuming A1 is your drop down cell and the sumif is your statement you've already created to capture all other scenarios in the drop down. Hope this helps
Thanks for responding! I tried that, but it would only work if is using one drop list. I couldn't find a way to make that formula work with a sumifs referencing multiple drop down lists. I discovered any easy solution - using "*" as wildcard in place of "All" in my reference list will pull in all data for each list criteria. ie List 1 (Month): "*", Jan, Feb, March, etc. List 2 (Region): "*", North, South, East , West if i wanted to find cost based on month and region the wildcard would allow me to toggle all month region combos including cost for all months for a given region, and all regions for a given month. I know this is a very awkward, long explanation, but I wanted to share to share my discovery! Thanks again!
What if i want to check quantity sold for all months and year for specific item number..any idea
Hi, I have a question, if i have columns that already have drop down lists-for example one that says "colors" and one that says "shapes". Am i able put a sum table where if i choose for example "blue" and square" and it automatically sums up those choices? Thank you!
What if you wanted to filter your sales data, would your "total value sold" return the Sum. Would it know to include/exclude what's filtered?
Thanks for posting. What if you wanted to add something like "All" to your list,? Can you use sumifs to sum all "Month_Year" or all "Item Numbers"?
Yes you could. One way is you could add an IF statement and nest your SUMIF in the false section of your if statement =IF(A1="All",sum(qtycolumn),SUMIF()).
Assuming A1 is your drop down cell and the sumif is your statement you've already created to capture all other scenarios in the drop down.
Hope this helps
Thanks for responding! I tried that, but it would only work if is using one drop list. I couldn't find a way to make that formula work with a sumifs referencing multiple drop down lists.
I discovered any easy solution - using "*" as wildcard in place of "All" in my reference list will pull in all data for each list criteria.
ie List 1 (Month): "*", Jan, Feb, March, etc.
List 2 (Region): "*", North, South, East , West
if i wanted to find cost based on month and region the wildcard would allow me to toggle all month region combos including cost for all months for a given region, and all regions for a given month.
I know this is a very awkward, long explanation, but I wanted to share to share my discovery!
Thanks again!
Excample
1/03/2017 Bopha 1
1/03/2017 Bopha 0.5
1/03/2017 Bora 1.5
1/03/2017 Bora 0.5
1/03/2017 Bora 2
1/03/2017 Mak 1
2/03/2017 Bopha 1
3/03/2017 Bopha 0.5
I want To date 01/03/2017 Bopha Sum?
@@Bradedgardotcom This was what I was looking for... so simple! Why did I struggle with this? Thanks!
Can you post dynamic drop down list with count
How to use Sumif function with multiple condition in drop-down box
hi Ser can you send video sum select date
Please give the file, sir