Counting text criteria

I have two columns Column A contains contract numbers, i.e. s4802,
s5601--column b contains status words i.e. pending, approved, withdrawn. I
need a formula that will provide a count of each status by contact.

=SUMPRODUCT(--(A2:A100="s4802"),--(B2:B100="pending"))

or better

=SUMPRODUCT(--(A2:A100=C2),--(B2:B100=D2))

where C2 holds the contract you want to check and D2 the status, that way
you won't have to edit the formula when you change the criteria

--

Regards,

Peo Sjoblom


"Belinda" <Belinda@discussions.microsoft.com> wrote in message
news:DB7511A4-B877-4122-9851-9C2CDF6F0E46@microsoft.com...
> I have two columns Column A contains contract numbers, i.e. s4802,
> s5601--column b contains status words i.e. pending, approved, withdrawn.
I
> need a formula that will provide a count of each status by contact.