software

Thank you for earlier response... have the formula now to count blank cells.

Been perusing your other answers but now have this question...

Scenario: one column, c4:c34. Will contain some numbers, some zeros, and
some necessary blank rows in case I add more information (either zero's or
numbers). Realized I didn't need to count the blank rows, just the zeros and
the numbers.

I can now count all the cells with zero's. How do I count the cells that
are greater than zero? I've tried a variety of formulas but my guess'n golly
hasn't eureka'd yet!

Linda

Have you tried
=COUNTIF(C4:C34,quot;gt;0quot;)--
goto_guy
------------------------------------------------------------------------
goto_guy's Profile: www.excelforum.com/member.php...oamp;userid=30557
View this thread: www.excelforum.com/showthread...hreadid=528316Yes, I've tried that and other variations from the discussion group answers
that seemed logical... well for the questions posed they were...

Anyway...That one you show returns a value of quot;0quot;. In that column of 31
cells, two contain numbers, 3 contain zeros, and the rest are blank. I can
count the zero's, I can count the blanks, but counting the numbered cells is
..... well .... I'm drawing a blank.

quot;goto_guyquot; wrote:

gt;
gt; Have you tried
gt; =COUNTIF(C4:C34,quot;gt;0quot;)
gt;
gt;
gt; --
gt; goto_guy
gt; ------------------------------------------------------------------------
gt; goto_guy's Profile: www.excelforum.com/member.php...oamp;userid=30557
gt; View this thread: www.excelforum.com/showthread...hreadid=528316
gt;
gt;

Then it's simple, they must be text.--

Regards,

Peo Sjoblom

nwexcelsolutions.com
quot;LIndaquot; gt; wrote in message
...
gt; Yes, I've tried that and other variations from the discussion group
gt; answers
gt; that seemed logical... well for the questions posed they were...
gt;
gt; Anyway...That one you show returns a value of quot;0quot;. In that column of 31
gt; cells, two contain numbers, 3 contain zeros, and the rest are blank. I
gt; can
gt; count the zero's, I can count the blanks, but counting the numbered cells
gt; is
gt; .... well .... I'm drawing a blank.
gt;
gt; quot;goto_guyquot; wrote:
gt;
gt;gt;
gt;gt; Have you tried
gt;gt; =COUNTIF(C4:C34,quot;gt;0quot;)
gt;gt;
gt;gt;
gt;gt; --
gt;gt; goto_guy
gt;gt; ------------------------------------------------------------------------
gt;gt; goto_guy's Profile:
gt;gt; www.excelforum.com/member.php...oamp;userid=30557
gt;gt; View this thread:
gt;gt; www.excelforum.com/showthread...hreadid=528316
gt;gt;
gt;gt;
Sounds like your numbers are being stored as text. If this returns a value

=SUMPRODUCT(--(C4:C34gt;0))

that will confirm it.

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

quot;LIndaquot; gt; wrote in message
...
gt; Yes, I've tried that and other variations from the discussion group
answers
gt; that seemed logical... well for the questions posed they were...
gt;
gt; Anyway...That one you show returns a value of quot;0quot;. In that column of 31
gt; cells, two contain numbers, 3 contain zeros, and the rest are blank. I
can
gt; count the zero's, I can count the blanks, but counting the numbered cells
is
gt; .... well .... I'm drawing a blank.
gt;
gt; quot;goto_guyquot; wrote:
gt;
gt; gt;
gt; gt; Have you tried
gt; gt; =COUNTIF(C4:C34,quot;gt;0quot;)
gt; gt;
gt; gt;
gt; gt; --
gt; gt; goto_guy
gt; gt; ------------------------------------------------------------------------
gt; gt; goto_guy's Profile:
www.excelforum.com/member.php...oamp;userid=30557
gt; gt; View this thread:
www.excelforum.com/showthread...hreadid=528316
gt; gt;
gt; gt;
Sorry, that formula returned a value of 5 which is counting the 2 cells with
numbers plus the 3 cells with zeros.
Not the right one yet.... need it to return a value of 2, and then that'll
probably be the right formula. What could be simpler than counting anything
greater than 0? The answer's here somewhere.
Linda

quot;Bob Phillipsquot; wrote:

gt; Sounds like your numbers are being stored as text. If this returns a value
gt;
gt; =SUMPRODUCT(--(C4:C34gt;0))
gt;
gt; that will confirm it.
gt;
gt; --
gt;
gt; HTH
gt;
gt; Bob Phillips
gt;
gt; (remove nothere from the email address if mailing direct)
gt;
gt; quot;LIndaquot; gt; wrote in message
gt; ...
gt; gt; Yes, I've tried that and other variations from the discussion group
gt; answers
gt; gt; that seemed logical... well for the questions posed they were...
gt; gt;
gt; gt; Anyway...That one you show returns a value of quot;0quot;. In that column of 31
gt; gt; cells, two contain numbers, 3 contain zeros, and the rest are blank. I
gt; can
gt; gt; count the zero's, I can count the blanks, but counting the numbered cells
gt; is
gt; gt; .... well .... I'm drawing a blank.
gt; gt;
gt; gt; quot;goto_guyquot; wrote:
gt; gt;
gt; gt; gt;
gt; gt; gt; Have you tried
gt; gt; gt; =COUNTIF(C4:C34,quot;gt;0quot;)
gt; gt; gt;
gt; gt; gt;
gt; gt; gt; --
gt; gt; gt; goto_guy
gt; gt; gt; ------------------------------------------------------------------------
gt; gt; gt; goto_guy's Profile:
gt; www.excelforum.com/member.php...oamp;userid=30557
gt; gt; gt; View this thread:
gt; www.excelforum.com/showthread...hreadid=528316
gt; gt; gt;
gt; gt; gt;
gt;
gt;
gt;

Oh, and I reconfirmed that the row of cells c4:c34 are formatted as number,
not text. No difference in the result.

quot;LIndaquot; wrote:

gt; Sorry, that formula returned a value of 5 which is counting the 2 cells with
gt; numbers plus the 3 cells with zeros.
gt; Not the right one yet.... need it to return a value of 2, and then that'll
gt; probably be the right formula. What could be simpler than counting anything
gt; greater than 0? The answer's here somewhere.
gt; Linda
gt;
gt; quot;Bob Phillipsquot; wrote:
gt;
gt; gt; Sounds like your numbers are being stored as text. If this returns a value
gt; gt;
gt; gt; =SUMPRODUCT(--(C4:C34gt;0))
gt; gt;
gt; gt; that will confirm it.
gt; gt;
gt; gt; --
gt; gt;
gt; gt; HTH
gt; gt;
gt; gt; Bob Phillips
gt; gt;
gt; gt; (remove nothere from the email address if mailing direct)
gt; gt;
gt; gt; quot;LIndaquot; gt; wrote in message
gt; gt; ...
gt; gt; gt; Yes, I've tried that and other variations from the discussion group
gt; gt; answers
gt; gt; gt; that seemed logical... well for the questions posed they were...
gt; gt; gt;
gt; gt; gt; Anyway...That one you show returns a value of quot;0quot;. In that column of 31
gt; gt; gt; cells, two contain numbers, 3 contain zeros, and the rest are blank. I
gt; gt; can
gt; gt; gt; count the zero's, I can count the blanks, but counting the numbered cells
gt; gt; is
gt; gt; gt; .... well .... I'm drawing a blank.
gt; gt; gt;
gt; gt; gt; quot;goto_guyquot; wrote:
gt; gt; gt;
gt; gt; gt; gt;
gt; gt; gt; gt; Have you tried
gt; gt; gt; gt; =COUNTIF(C4:C34,quot;gt;0quot;)
gt; gt; gt; gt;
gt; gt; gt; gt;
gt; gt; gt; gt; --
gt; gt; gt; gt; goto_guy
gt; gt; gt; gt; ------------------------------------------------------------------------
gt; gt; gt; gt; goto_guy's Profile:
gt; gt; www.excelforum.com/member.php...oamp;userid=30557
gt; gt; gt; gt; View this thread:
gt; gt; www.excelforum.com/showthread...hreadid=528316
gt; gt; gt; gt;
gt; gt; gt; gt;
gt; gt;
gt; gt;
gt; gt;

It wasn't meant to be an alternative, just confirmed they are text, which it
did. Change them to General and F2 the text cells.

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

quot;LIndaquot; gt; wrote in message
news
gt; Sorry, that formula returned a value of 5 which is counting the 2 cells
with
gt; numbers plus the 3 cells with zeros.
gt; Not the right one yet.... need it to return a value of 2, and then that'll
gt; probably be the right formula. What could be simpler than counting
anything
gt; greater than 0? The answer's here somewhere.
gt; Linda
gt;
gt; quot;Bob Phillipsquot; wrote:
gt;
gt; gt; Sounds like your numbers are being stored as text. If this returns a
value
gt; gt;
gt; gt; =SUMPRODUCT(--(C4:C34gt;0))
gt; gt;
gt; gt; that will confirm it.
gt; gt;
gt; gt; --
gt; gt;
gt; gt; HTH
gt; gt;
gt; gt; Bob Phillips
gt; gt;
gt; gt; (remove nothere from the email address if mailing direct)
gt; gt;
gt; gt; quot;LIndaquot; gt; wrote in message
gt; gt; ...
gt; gt; gt; Yes, I've tried that and other variations from the discussion group
gt; gt; answers
gt; gt; gt; that seemed logical... well for the questions posed they were...
gt; gt; gt;
gt; gt; gt; Anyway...That one you show returns a value of quot;0quot;. In that column of
31
gt; gt; gt; cells, two contain numbers, 3 contain zeros, and the rest are blank.
I
gt; gt; can
gt; gt; gt; count the zero's, I can count the blanks, but counting the numbered
cells
gt; gt; is
gt; gt; gt; .... well .... I'm drawing a blank.
gt; gt; gt;
gt; gt; gt; quot;goto_guyquot; wrote:
gt; gt; gt;
gt; gt; gt; gt;
gt; gt; gt; gt; Have you tried
gt; gt; gt; gt; =COUNTIF(C4:C34,quot;gt;0quot;)
gt; gt; gt; gt;
gt; gt; gt; gt;
gt; gt; gt; gt; --
gt; gt; gt; gt; goto_guy
gt; gt; gt;
gt; ------------------------------------------------------------------------
gt; gt; gt; gt; goto_guy's Profile:
gt; gt; www.excelforum.com/member.php...oamp;userid=30557
gt; gt; gt; gt; View this thread:
gt; gt; www.excelforum.com/showthread...hreadid=528316
gt; gt; gt; gt;
gt; gt; gt; gt;
gt; gt;
gt; gt;
gt; gt;
It doesn't matter if they are formatted as numbers, excel sees them as text,
no formatting will change that, you will need to calculate them if they
don't have trailing or leading spaces..

Try by copying an empty cell, select the range and do editgt;paste special and
select add..

then use the countif function

If that doesn't work you have invisible characters like html char(160) or
spaces in the cells--

Regards,

Peo Sjoblom

nwexcelsolutions.com
quot;LIndaquot; gt; wrote in message
...
gt; Oh, and I reconfirmed that the row of cells c4:c34 are formatted as
gt; number,
gt; not text. No difference in the result.
gt;
gt; quot;LIndaquot; wrote:
gt;
gt;gt; Sorry, that formula returned a value of 5 which is counting the 2 cells
gt;gt; with
gt;gt; numbers plus the 3 cells with zeros.
gt;gt; Not the right one yet.... need it to return a value of 2, and then
gt;gt; that'll
gt;gt; probably be the right formula. What could be simpler than counting
gt;gt; anything
gt;gt; greater than 0? The answer's here somewhere.
gt;gt; Linda
gt;gt;
gt;gt; quot;Bob Phillipsquot; wrote:
gt;gt;
gt;gt; gt; Sounds like your numbers are being stored as text. If this returns a
gt;gt; gt; value
gt;gt; gt;
gt;gt; gt; =SUMPRODUCT(--(C4:C34gt;0))
gt;gt; gt;
gt;gt; gt; that will confirm it.
gt;gt; gt;
gt;gt; gt; --
gt;gt; gt;
gt;gt; gt; HTH
gt;gt; gt;
gt;gt; gt; Bob Phillips
gt;gt; gt;
gt;gt; gt; (remove nothere from the email address if mailing direct)
gt;gt; gt;
gt;gt; gt; quot;LIndaquot; gt; wrote in message
gt;gt; gt; ...
gt;gt; gt; gt; Yes, I've tried that and other variations from the discussion group
gt;gt; gt; answers
gt;gt; gt; gt; that seemed logical... well for the questions posed they were...
gt;gt; gt; gt;
gt;gt; gt; gt; Anyway...That one you show returns a value of quot;0quot;. In that column of
gt;gt; gt; gt; 31
gt;gt; gt; gt; cells, two contain numbers, 3 contain zeros, and the rest are blank.
gt;gt; gt; gt; I
gt;gt; gt; can
gt;gt; gt; gt; count the zero's, I can count the blanks, but counting the numbered
gt;gt; gt; gt; cells
gt;gt; gt; is
gt;gt; gt; gt; .... well .... I'm drawing a blank.
gt;gt; gt; gt;
gt;gt; gt; gt; quot;goto_guyquot; wrote:
gt;gt; gt; gt;
gt;gt; gt; gt; gt;
gt;gt; gt; gt; gt; Have you tried
gt;gt; gt; gt; gt; =COUNTIF(C4:C34,quot;gt;0quot;)
gt;gt; gt; gt; gt;
gt;gt; gt; gt; gt;
gt;gt; gt; gt; gt; --
gt;gt; gt; gt; gt; goto_guy
gt;gt; gt; gt; gt; ------------------------------------------------------------------------
gt;gt; gt; gt; gt; goto_guy's Profile:
gt;gt; gt; www.excelforum.com/member.php...oamp;userid=30557
gt;gt; gt; gt; gt; View this thread:
gt;gt; gt; www.excelforum.com/showthread...hreadid=528316
gt;gt; gt; gt; gt;
gt;gt; gt; gt; gt;
gt;gt; gt;
gt;gt; gt;
gt;gt; gt;
EUREKA!
It worked.
I don't understand how, but all I need is the right formula for now.
Linda

quot;Peo Sjoblomquot; wrote:

gt; It doesn't matter if they are formatted as numbers, excel sees them as text,
gt; no formatting will change that, you will need to calculate them if they
gt; don't have trailing or leading spaces..
gt;
gt; Try by copying an empty cell, select the range and do editgt;paste special and
gt; select add..
gt;
gt; then use the countif function
gt;
gt; If that doesn't work you have invisible characters like html char(160) or
gt; spaces in the cells
gt;
gt;
gt; --
gt;
gt; Regards,
gt;
gt; Peo Sjoblom
gt;
gt; nwexcelsolutions.com
gt;
gt;
gt;
gt; quot;LIndaquot; gt; wrote in message
gt; ...
gt; gt; Oh, and I reconfirmed that the row of cells c4:c34 are formatted as
gt; gt; number,
gt; gt; not text. No difference in the result.
gt; gt;
gt; gt; quot;LIndaquot; wrote:
gt; gt;
gt; gt;gt; Sorry, that formula returned a value of 5 which is counting the 2 cells
gt; gt;gt; with
gt; gt;gt; numbers plus the 3 cells with zeros.
gt; gt;gt; Not the right one yet.... need it to return a value of 2, and then
gt; gt;gt; that'll
gt; gt;gt; probably be the right formula. What could be simpler than counting
gt; gt;gt; anything
gt; gt;gt; greater than 0? The answer's here somewhere.
gt; gt;gt; Linda
gt; gt;gt;
gt; gt;gt; quot;Bob Phillipsquot; wrote:
gt; gt;gt;
gt; gt;gt; gt; Sounds like your numbers are being stored as text. If this returns a
gt; gt;gt; gt; value
gt; gt;gt; gt;
gt; gt;gt; gt; =SUMPRODUCT(--(C4:C34gt;0))
gt; gt;gt; gt;
gt; gt;gt; gt; that will confirm it.
gt; gt;gt; gt;
gt; gt;gt; gt; --
gt; gt;gt; gt;
gt; gt;gt; gt; HTH
gt; gt;gt; gt;
gt; gt;gt; gt; Bob Phillips
gt; gt;gt; gt;
gt; gt;gt; gt; (remove nothere from the email address if mailing direct)
gt; gt;gt; gt;
gt; gt;gt; gt; quot;LIndaquot; gt; wrote in message
gt; gt;gt; gt; ...
gt; gt;gt; gt; gt; Yes, I've tried that and other variations from the discussion group
gt; gt;gt; gt; answers
gt; gt;gt; gt; gt; that seemed logical... well for the questions posed they were...
gt; gt;gt; gt; gt;
gt; gt;gt; gt; gt; Anyway...That one you show returns a value of quot;0quot;. In that column of
gt; gt;gt; gt; gt; 31
gt; gt;gt; gt; gt; cells, two contain numbers, 3 contain zeros, and the rest are blank.
gt; gt;gt; gt; gt; I
gt; gt;gt; gt; can
gt; gt;gt; gt; gt; count the zero's, I can count the blanks, but counting the numbered
gt; gt;gt; gt; gt; cells
gt; gt;gt; gt; is
gt; gt;gt; gt; gt; .... well .... I'm drawing a blank.
gt; gt;gt; gt; gt;
gt; gt;gt; gt; gt; quot;goto_guyquot; wrote:
gt; gt;gt; gt; gt;
gt; gt;gt; gt; gt; gt;
gt; gt;gt; gt; gt; gt; Have you tried
gt; gt;gt; gt; gt; gt; =COUNTIF(C4:C34,quot;gt;0quot;)
gt; gt;gt; gt; gt; gt;
gt; gt;gt; gt; gt; gt;
gt; gt;gt; gt; gt; gt; --
gt; gt;gt; gt; gt; gt; goto_guy
gt; gt;gt; gt; gt; gt; ------------------------------------------------------------------------
gt; gt;gt; gt; gt; gt; goto_guy's Profile:
gt; gt;gt; gt; www.excelforum.com/member.php...oamp;userid=30557
gt; gt;gt; gt; gt; gt; View this thread:
gt; gt;gt; gt; www.excelforum.com/showthread...hreadid=528316
gt; gt;gt; gt; gt; gt;
gt; gt;gt; gt; gt; gt;
gt; gt;gt; gt;
gt; gt;gt; gt;
gt; gt;gt; gt;
gt;
gt;
gt;