using SUMIFS and adding values based on multiple criteria based on selection from the drop

Without getting into your sheet... are you asking how to make excel accept all of a field... if the word ALL is selected. For this you would likely need to set up your sheet to have cells off to the side in which your formulas are looking...

Example... If your selection menu is in cell C6, then in D6 say

Please Login or Register  to view this content.

then all of your formulas should be looking to D6 for the criteria, this way the wildcard * will be the criteria for the field allowing you to get everything, or if you happen to select something else you will still get that value for the criteria within your report. . .

Cheers

Hey muheebrahman,

I thought you had a sheet last time I looked at this post, might just be my PC right now but it does not appear to be visible anymore. Basically you can do one of 2 things. You can make a separate location that is based on those selections you make in report writer. I was suggesting putting them right next to them but they can be in a separate sheet all together. What you would do is like I say in my formula is say If the selection is ALL then equal wildcard (*) otherwise equal original selection. Then all the formulas would look to this new reference instead of the original... OR you can add to your formulas, for the criteria, IF(SELECTION="ALL","*",SELECTION). Of course SELECTION would be your reference to the drop downs on your report writer.