Cat wrote:
I'm trying to find a way to build a conditional formula to return the
following values:

Count when Column F = X AND when Column J = A or B.

Hi Cat,

Here is one way of doing it:

=SUMPRODUCT(--(F1:F10="X"),--(J1:J10="A"))+SUMPRODUCT(--(F1:F10="X"),--(J1:J10="B"))

Note that you can not use the entire rows in the formula but have to
specifie a range.

Regards,
Bondi