Excel 2007 : Using Countifs to count muliple criteris from the same column?

Hi All,



Trust you all have a great Festive Season.



I have been doing a Countifs to obtain the number of times a job has been done in a month, by 2 certain criteria, on a single action?



Basically in 1 column I will have a list of months

2nd column will have a list of action ie Operator, Repair Outsource

3rd column number of action per job.



I need to count how many jan jobs were Repair and Operator with 1 action on.



I hope this makes sense.



I can use the countifs to obtain the month, actions, but only 1 of repair or Operator, how can I get both the Operator and repair jobs in a single count.



I have attached an example for you to play with



Looking forward to your suggestions



Donna

Hi

Maybe this?

=SUMPRODUCT(($A$2:$A$6="JAN")*($B$2:$B$6="OPERATOR")*($C$2:$C$6))+SUMPRODUCT(($A$2:$A$6="JAN")*($B$2:$B$6="REPAIR")*($C$2:$C$6))

Hope to helps you.

So Donna, if i understoond well your point, you like to COUNT, NOT add.

So try this.

=SUMPRODUCT(($A$2:$A$6="JAN")*($B$2:$B$6="OPERATOR")*($C$2:$C$6=1))+SUMPRODUCT(($A$2:$A$6="JAN")*($B$2:$B$6="REPAIR")*($C$2:$C$6=1))

Hope to be OK, now.

Yes you can do it!

=SUMPRODUCT(($A$2:$A$6=A2)*($B$2:$B$6="OPERATOR")*($C$2:$C$6=1))+SUMPRODUCT(($A$2:$A$6=A2)*($B$2:$B$6="REPAIR")*($C$2:$C$6=1))

You are welcome! Glad to helped you!