If statements & countif(s)

[cocoonfx]

Hello


I have a spreadsheet where i have to count the number of claims which have been made.

For example i have cell b2:b6000 inwhich i have a list of valables which would be 601 or 602 i then i have cell g2:g6000 which has claim and no claim.

I want to find out the total number of claims for 601?

i have tried a combination of if statements and countif statements which doesn't work does any one know how i can do this?

 

[Ian Mac]

=SUMPRODUCT(($B$2:$B$6000=601)*($G$2:$G$6000="Claim"))

Hope that helps