COUNTIF?
I need to count numbered text, such as, "100A" in a column.
|
COUNTIF?
If you need to count the number of numerical values use =COUNT(), if you need
to count the total number of populated cells (numerical values and text values) use =COUNTA(). -- Regards, Dave "Vegs" wrote: I need to count numbered text, such as, "100A" in a column. |
COUNTIF?
I created a workbook and entered some dummy text values, such as 100A, 110A,
1201 Then I used =COUNTIF(A1:A3,"100A") and it returned 1, which is correct. "Vegs" wrote: I need to count numbered text, such as, "100A" in a column. |
COUNTIF?
=countif(a:a,"100a") -- Vito ------------------------------------------------------------------------ Vito's Profile: http://www.excelforum.com/member.php...o&userid=29182 View this thread: http://www.excelforum.com/showthread...hreadid=494665 |
COUNTIF?
Thanks Dave...
I needed to add "*100A*" to the COUNTIF fucntion. "David Billigmeier" wrote: If you need to count the number of numerical values use =COUNT(), if you need to count the total number of populated cells (numerical values and text values) use =COUNTA(). -- Regards, Dave "Vegs" wrote: I need to count numbered text, such as, "100A" in a column. |
COUNTIF?
Thanks Pats,
The spreadsheet was generated from another program so the values weren't centered in the cell...I added asterisks "*100A*" to the formula and it works.. "Pats" wrote: I created a workbook and entered some dummy text values, such as 100A, 110A, 1201 Then I used =COUNTIF(A1:A3,"100A") and it returned 1, which is correct. "Vegs" wrote: I need to count numbered text, such as, "100A" in a column. |
COUNTIF?
Vegs
=countif(A:A, "100A") Gord Dibben Excel MVP On Mon, 19 Dec 2005 10:56:02 -0800, "Vegs" wrote: I need to count numbered text, such as, "100A" in a column. |
All times are GMT +1. The time now is 06:04 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com