#### Big Monkey

##### Active Member

- Joined
- Nov 5, 2005

- Messages
- 255

I have a simple formula now like

=COUNTA(A2:A65536)

What I want to do is get the same result, but only of column I on the same row contains "mytext"

So:

Col A

1

1

1

1

This would equal to 4 with my formula.

Col A Col B

1 mytext

1

1 mytext

1

How would I write the formula for the above to give me a value of 2?

I tried using a sumproduct, but that is totaling the numbers in column A, and I only want the counta values.