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

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

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"

2. ## Re: Formula needed to only count total cells entered and not count adjacent text entered c

Like this...

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

EDIT: I think I misunderstood your requirement.

Try this:

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

3. ## Re: Formula needed to only count total cells entered and not count adjacent text entered c

Try one of...

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

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

4. ## Re: Formula needed to only count total cells entered and not count adjacent text entered c

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

5. ## Re: Formula needed to only count total cells entered and not count adjacent text entered c

thank you it works

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1