troubleshooting Question

Special criteria in a SUMIFS

Avatar of Hans de Jongh
Hans de JonghFlag for Netherlands asked on
Microsoft ExcelMicrosoft Office
6 Comments1 Solution95 ViewsLast Modified:

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 Raw Data'!Z:Z;C14)

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?
Join our community to see this answer!
Unlock 1 Answer and 6 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 6 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros