Formula needed to only count total cells entered and not count adjacent text entered cells

[excelteam777]

I want to count the cells with data entered and not count those that have a text entry in another cell.

A1:A10 = entered numbers
B1:B10 = entered text
C1 = formula

If i completely enter data in each of the 10 A cells, however in B1, B2, and B3 I enter "X", I want C1 to show 7 for the number of ells that have data not pertaining to "X"

[Tony Valko]

Like this...

=COUNTIF(B1:B10,"<>X")

EDIT: I think I misunderstood your requirement.

Try this:

=COUNTIFS(A1:A10,"<>",B1:B10,"<>X")

[Aladin Akyurek]

Try one of...

=COUNTIFS(A1:A10,"<>",B1:B10,"<>X")

=SUMPRODUCT(1-(A1:A10=""),1-(B1:B10="X"))

[FDibbins]

If B can contain text or numeric, try this...
=COUNTIFS(A1:A10,">0",B1:B10,"<>")

[excelteam777]

thank you it works