Hi All,
I need to add some extra conditions to the formula below, any ideas as to how this is done would be great.

=COUNTIFS(Netc!C4:C1008,"open",Netc!D41008,"PC")
This works ok for just one condition

I need to add the following somehow...

=COUNTIFS(Netc!C4:C1008,"open" or "Waiting Parts",Netc!D41008,"PC")



or do I need to add separate countifs to do it?

Try...

=SUM(COUNTIFS(Netc!C4:C1008,{"open","Waiting Parts"},Netc!D4: D1008,"PC")

Note: No space between the the colon and the D1008. The board is thinking the : and the D combined is a smiley face.

If you want a little explanation you'll find it here

Thanks but I had tried that already and it didn't work, it only found the first variable, I even swapped them to confirm this.

I think I'll go with using the above single variable and add extra countifs with a "+" in between to get the result I need. seems to work ok.

=COUNTIFS(Netc!C4:C1008,"open",Netc!D41008 ,"PC") + COUNTIFS(Netc!C4:C1008,"waiting parts",Netc!D41008 ,"PC")

Well we tried. It works with the test file I have, but unfortunately I don't have what you are testing. If you want to post a sample where it doesn't work I would be happy to look at it.

Here's a sample of the problem I have, it sees only the first selection ???

Repairs Received .xlsx

Just an updated thought.
Can I use a list for this in some way?

Yes you can use a list, but to do that you will now need to wrap the Countifs in Sumproduct.

=SUMPRODUCT(COUNTIFS(Netcard!$C$4:$C$20,$F$1:$F$2, Netcard!$D$4:$D$20,"Kiosk Assembly"))

F1:F2 = Waiting Parts and Open

BTW: In the file you attached, you did not have the Countifs wrapped in Sum. It must be wrapped in order for the OR operation to take effect.

Post moved to non VBA section
@trevorc Please post in the correct forum - Thx

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

thanks for that... works fine now.