Hans de Jongh
asked on
Countifs doesnt work
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
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.