This gives the count of cells in A1:A10 that do not begin with "open",
"closed", or "Canceled".
Includes blank cells:
=SUMPRODUCT((LEFT(A1:A10,4)<"open")*(LEFT(A1:A10, 6)<"closed")*(LEFT(A1:A10,6)<"Cancel"))
If you don't wan't blanks:
=SUMPRODUCT((LEFT(A1:A10,4)<"open")*(LEFT(A1:A10, 6)<"closed")*(LEFT(A1:A10,6)<"Cancel")*(NOT(ISBL ANK(A1:A10))))
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"linda" wrote:

How do I create a formula to count using begins with. Example, I want to
count the number of time the column begins with other than closed, cancel,
Open, or column is blank. I already have the columns that start with open,
closed, etc counting for the total number that are open or closed. I also
need to know the number of time the column starts with other than open,
closed, etc. Countblank is also counting the number of blank columns. The
columns are all words and not number value, but I want the accurance to
count. I was thinking there should be a way to countif columns does not
begin with "open, closed or Cancel" but I can not get it to work. Hope you
can help.

Columns;

Open
Cancelled due to transfer
Planning/Research
Draft Report
Closed