conditional count

[Amanda]

Hi Brian,

I would add a fourth columns *D* and put the following IF
formula in:

=IF(A12="M",IF(C12="P",B12),"")

This will return the value in column B, if both M & P are
present. If one or both are missing it will leave the
field blank (""). if you would like it so say 0 replace
the final two "" with 0 in the formula.

This fourth column can then be totalled at the bottom.

Hope this is helpful!

Amanda