How to count cells that meet two criteria. Please Help!

**Doolie01** · 06-18-2013, 02:00 PM

Hello,

I'm having some issues trying to count some cells with multiple criteria.

I've got two sheets, one named Contract Manager and the other named Target Manager.

What I'm trying to do is count how many contracts in column C of the Target manager equals a specific contract on the contract manager page that's expiry date in column O of the target manager are later than or equal to today.

This is what I've got worked out so far but it only brings back a 0 which I know is wrong.

=SUMPRODUCT(--('Target Manager'!$C$4:$C$124="B4"),--('Target Manager'!$O$4:$O$124>="TODAY()"))

Any help would be greatly appreciated.

Thanks

**Ace_XL** · 06-18-2013, 02:05 PM

Do away with the " " for cell references and formulas, else Excel reads them as text

Hence
=SUMPRODUCT(--('Target Manager'!$C$4:$C$124=B4),--('Target Manager'!$O$4:$O$124>=TODAY()))