I'm very new at excel and I'm having some problems with COUNTIF. Perhaps, I'm using the wrong formula.
I've attached a simplified example.
I want to have two different values retuned:
1. Count # of Recommended Orders >0 where the Order Qty does not equal to 0 but is <> Recommended Order (I attempted this formula in F3...no laughing please)
2. Count # of Recommended Orders >0 that match Order Qty
Attachment 418157
Bookmarks