If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Not Counting cells that have a formula with ""
I have a column of cells with a formulas that have
=If(c4 0, "test", ""). This is the simple form, as there is a few if and countifs that can produce differnt results, like test, testing, testicle. How can I count only the cells that have someting in them, basically the blank cells. Thanks, Steve |
#2
|
|||
|
|||
Not Counting cells that have a formula with ""
That should be "... basically NOT the blank cells."
"Steve" wrote: I have a column of cells with a formulas that have =If(c4 0, "test", ""). This is the simple form, as there is a few if and countifs that can produce differnt results, like test, testing, testicle. How can I count only the cells that have someting in them, basically NOT the blank cells. Thanks, Steve |
#3
|
|||
|
|||
Not Counting cells that have a formula with ""
=SUMPRODUCT(N(LEN(A1:A100)0))
Bob Umlas Excel MVP ("Steve" wrote in message ... I have a column of cells with a formulas that have =If(c4 0, "test", ""). This is the simple form, as there is a few if and countifs that can produce differnt results, like test, testing, testicle. How can I count only the cells that have someting in them, basically the blank cells. Thanks, Steve |
#4
|
|||
|
|||
Not Counting cells that have a formula with ""
Steve wrote...
I have a column of cells with a formulas that have =If(c4 0, "test", ""). This is the simple form, as there is a few if and countifs that can produce differnt results, like test, testing, testicle. How can I count only the cells that have someting in them, basically the blank cells. The 'blank' cells? Do you mean the NONblank cells? =COUNTIF(range,"?*") to count only text strings, or =COUNTIF(range,"?*")+COUNT(range) to count nonblank text strings and numbers, or =ROWS(range)*COLUMNS(range)-COUNTBLANK(range) to count nonblank cells evaluating to anything other than "". |
#5
|
|||
|
|||
Not Counting cells that have a formula with ""
This will count all *TEXT* entries in the range and will *exclude* cells
that contain formula blanks: =COUNTIF(B:B,"?*") -- Biff Microsoft Excel MVP "Steve" wrote in message ... I have a column of cells with a formulas that have =If(c4 0, "test", ""). This is the simple form, as there is a few if and countifs that can produce differnt results, like test, testing, testicle. How can I count only the cells that have someting in them, basically the blank cells. Thanks, Steve |
#6
|
|||
|
|||
Not Counting cells that have a formula with ""
Wow ! That was fast, and it worked great.
One mo same situation in a differnt range, with formulas in the cells, producing either test, or various other text. How do I count the # of cells that do not have test in them ? Thanks agai, Steve "Bob Umlas" wrote: =SUMPRODUCT(N(LEN(A1:A100)0)) Bob Umlas Excel MVP ("Steve" wrote in message ... I have a column of cells with a formulas that have =If(c4 0, "test", ""). This is the simple form, as there is a few if and countifs that can produce differnt results, like test, testing, testicle. How can I count only the cells that have someting in them, basically the blank cells. Thanks, Steve |
#7
|
|||
|
|||
Not Counting cells that have a formula with ""
Yes, I did mean non-blank. And each of your solutions work great.
Much thanks, Steve "Harlan Grove" wrote: Steve wrote... I have a column of cells with a formulas that have =If(c4 0, "test", ""). This is the simple form, as there is a few if and countifs that can produce differnt results, like test, testing, testicle. How can I count only the cells that have someting in them, basically the blank cells. The 'blank' cells? Do you mean the NONblank cells? =COUNTIF(range,"?*") to count only text strings, or =COUNTIF(range,"?*")+COUNT(range) to count nonblank text strings and numbers, or =ROWS(range)*COLUMNS(range)-COUNTBLANK(range) to count nonblank cells evaluating to anything other than "". |
Thread Tools | |
Display Modes | |
|
|