troubleshooting Question

Countifs doesnt work

Avatar of Hans de Jongh
Hans de JonghFlag for Netherlands asked on
Microsoft ExcelMicrosoft Office
1 Comment1 Solution59 ViewsLast Modified:
Hello,

in the following table every line within revenue is an order.
I want to count the number of orders for the first month except the order for customer C.

How can i do that? countifs doens return an error

month      revenue      Extra      customer
1       € 10,00        € 5,00       a
1       € 20,00        € 2,00       a
1       € 25,00        € 4,00       b
1       € 40,00        € 5,00       c
2       € 50,00        € 1,00       a
2       € 1,00        € 66,00       a
2       € 4,00        € 32,00       b
2       € 182,00        € 2,00       c
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 1 Answer and 1 Comment.
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 1 Comment.
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