I am trying to get a sum when two criteria (text) are met. Here is an example
A B
CHAMBERS E
OSWA
OSWA
OSWA
CHAMBERS E


I would like to know how many times Chambers and E occur. My formula that I
have been working on was a sumproduct, but it appears not to be working form
me.