troubleshooting Question

Sum only certain criteria

Avatar of gisvpn
gisvpnFlag for United States of America asked on
Microsoft Excel
11 Comments1 Solution364 ViewsLast Modified:
Hello,

I have been using some SUMPRODUCT formulas but I cant get mine to work properly and I am sure its the way I am using it - could someone please help me out?

I have this :

=SUMPRODUCT(data!$B$2:$B$999=Red, data!$Z$2:$Z$999=$B$41,data!$Z$2:$Z$999=$B$42,data!$Z$2:$Z$999=$B$43,data!$Z$2:$Z$999=$B$44,data!$Z$2:$Z$999=$B$45)

I would like to count the number of rows which have Red in the B:B column on the data spreadsheet where the status (listed in the Z Column) is either of the ones noted in the cells above?

Have I missed the obvious?

Thanks,

GISVPN
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 1 Answer and 11 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 11 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