Special criteria in a SUMIFS
hello,
I have sumifs formula:
=SUMIFS('All Raw Data'!H:H;'All Raw Data'!Q:Q;2019;'All Raw Data'!R:R;2;'All Raw Data'!J:J;"<>XXXXXXX";'All
but I want something "special":)
C14 is a dropdown list which holds names.
Depending on the name I get a result. It works fine.
But I want IF C14 = X then it should just give everything. So the last criteria should then not be taken into consideration. So a total of H:H (still taking in a account Q:Q/R:R/J:J
is that possible?
I have sumifs formula:
=SUMIFS('All Raw Data'!H:H;'All Raw Data'!Q:Q;2019;'All Raw Data'!R:R;2;'All Raw Data'!J:J;"<>XXXXXXX";'All
but I want something "special":)
C14 is a dropdown list which holds names.
Depending on the name I get a result. It works fine.
But I want IF C14 = X then it should just give everything. So the last criteria should then not be taken into consideration. So a total of H:H (still taking in a account Q:Q/R:R/J:J
is that possible?
Last Comment
Roy Cox
Can you attach an example of the worksheet.
ASKER
no I can't the excel file contains to much info for the public web...
You shouldn't post an example with real names, etc. Just a a demo of the the data layout
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
you rock! thanks
You're welcome Hans!
Thanks for the feedback.
Thanks for the feedback.
Microsoft Excel
Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.
144K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
