|
countif clarification
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 |
countif clarification
Have you tried =COUNTIF(C4:C34,"0") -- goto_guy ------------------------------------------------------------------------ goto_guy's Profile: http://www.excelforum.com/member.php...o&userid=30557 View this thread: http://www.excelforum.com/showthread...hreadid=528316 |
countif clarification
Yes, 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 "0". 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. "goto_guy" wrote: Have you tried =COUNTIF(C4:C34,"0") -- goto_guy ------------------------------------------------------------------------ goto_guy's Profile: http://www.excelforum.com/member.php...o&userid=30557 View this thread: http://www.excelforum.com/showthread...hreadid=528316 |
countif clarification
Then it's simple, they must be text.
-- Regards, Peo Sjoblom http://nwexcelsolutions.com "LInda" wrote in message ... Yes, 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 "0". 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. "goto_guy" wrote: Have you tried =COUNTIF(C4:C34,"0") -- goto_guy ------------------------------------------------------------------------ goto_guy's Profile: http://www.excelforum.com/member.php...o&userid=30557 View this thread: http://www.excelforum.com/showthread...hreadid=528316 |
countif clarification
Sounds like your numbers are being stored as text. If this returns a value
=SUMPRODUCT(--(C4:C340)) that will confirm it. -- HTH Bob Phillips (remove nothere from the email address if mailing direct) "LInda" wrote in message ... Yes, 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 "0". 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. "goto_guy" wrote: Have you tried =COUNTIF(C4:C34,"0") -- goto_guy ------------------------------------------------------------------------ goto_guy's Profile: http://www.excelforum.com/member.php...o&userid=30557 View this thread: http://www.excelforum.com/showthread...hreadid=528316 |
countif clarification
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 "Bob Phillips" wrote: Sounds like your numbers are being stored as text. If this returns a value =SUMPRODUCT(--(C4:C340)) that will confirm it. -- HTH Bob Phillips (remove nothere from the email address if mailing direct) "LInda" wrote in message ... Yes, 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 "0". 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. "goto_guy" wrote: Have you tried =COUNTIF(C4:C34,"0") -- goto_guy ------------------------------------------------------------------------ goto_guy's Profile: http://www.excelforum.com/member.php...o&userid=30557 View this thread: http://www.excelforum.com/showthread...hreadid=528316 |
countif clarification
Oh, and I reconfirmed that the row of cells c4:c34 are formatted as number,
not text. No difference in the result. "LInda" wrote: 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 "Bob Phillips" wrote: Sounds like your numbers are being stored as text. If this returns a value =SUMPRODUCT(--(C4:C340)) that will confirm it. -- HTH Bob Phillips (remove nothere from the email address if mailing direct) "LInda" wrote in message ... Yes, 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 "0". 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. "goto_guy" wrote: Have you tried =COUNTIF(C4:C34,"0") -- goto_guy ------------------------------------------------------------------------ goto_guy's Profile: http://www.excelforum.com/member.php...o&userid=30557 View this thread: http://www.excelforum.com/showthread...hreadid=528316 |
countif clarification
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) "LInda" wrote in message ... 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 "Bob Phillips" wrote: Sounds like your numbers are being stored as text. If this returns a value =SUMPRODUCT(--(C4:C340)) that will confirm it. -- HTH Bob Phillips (remove nothere from the email address if mailing direct) "LInda" wrote in message ... Yes, 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 "0". 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. "goto_guy" wrote: Have you tried =COUNTIF(C4:C34,"0") -- goto_guy ------------------------------------------------------------------------ goto_guy's Profile: http://www.excelforum.com/member.php...o&userid=30557 View this thread: http://www.excelforum.com/showthread...hreadid=528316 |
countif clarification
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 editpaste 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 http://nwexcelsolutions.com "LInda" wrote in message ... Oh, and I reconfirmed that the row of cells c4:c34 are formatted as number, not text. No difference in the result. "LInda" wrote: 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 "Bob Phillips" wrote: Sounds like your numbers are being stored as text. If this returns a value =SUMPRODUCT(--(C4:C340)) that will confirm it. -- HTH Bob Phillips (remove nothere from the email address if mailing direct) "LInda" wrote in message ... Yes, 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 "0". 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. "goto_guy" wrote: Have you tried =COUNTIF(C4:C34,"0") -- goto_guy ------------------------------------------------------------------------ goto_guy's Profile: http://www.excelforum.com/member.php...o&userid=30557 View this thread: http://www.excelforum.com/showthread...hreadid=528316 |
countif clarification
EUREKA!
It worked. I don't understand how, but all I need is the right formula for now. Linda "Peo Sjoblom" wrote: 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 editpaste 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 http://nwexcelsolutions.com "LInda" wrote in message ... Oh, and I reconfirmed that the row of cells c4:c34 are formatted as number, not text. No difference in the result. "LInda" wrote: 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 "Bob Phillips" wrote: Sounds like your numbers are being stored as text. If this returns a value =SUMPRODUCT(--(C4:C340)) that will confirm it. -- HTH Bob Phillips (remove nothere from the email address if mailing direct) "LInda" wrote in message ... Yes, 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 "0". 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. "goto_guy" wrote: Have you tried =COUNTIF(C4:C34,"0") -- goto_guy ------------------------------------------------------------------------ goto_guy's Profile: http://www.excelforum.com/member.php...o&userid=30557 View this thread: http://www.excelforum.com/showthread...hreadid=528316 |
| All times are GMT +1. The time now is 06:21 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com