Countifs doesnt work

Hans de Jongh
Hans de Jongh used Ask the Experts™
on
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
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
IT / Software Engineering Consultant
Top Expert 2016
Commented:
Assuming the data you showed started in A1, then how about this?

=COUNTIFS(A2:A9,"=1",D2:D9,"<>c")

Open in new window


»bp

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial