Hi All,
I'm having trouble using the SUMPRODUCT formula. It is the first time I
have tried to use it. Below is some sample data.

Field 1 Field 2

Surrender 2
Disbursment 2
Surrender 1
Surrender 2

I am using the following formula:
=SUMPRODUCT((B2:B5)=2)*(A2:A5="Surrender")
I want the formula to return the value 2 as the combination of Surrender and
2 occurs 2 times. However it is returning the value of 0. Any help or
direction is greatly appreciated.
Thanks,

Mate.