Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Counting NUMBERS &/or TEXT from a column to other sheet ?
I am working with a workbook that contains two sheets. I need to count (all
in the same column) in one case a number/text combo (EXE & 000). In the next case I need to count only text (from same column as above!). I am a novice & thought simply using the "COUNT" would do it but have been at it for about an hour & cannot figure it out!!! Please help! |
#2
|
|||
|
|||
Use
=COUNT(A:A) and =COUNTA(A:A) -- HTH RP (remove nothere from the email address if mailing direct) "Trixie" wrote in message ... I am working with a workbook that contains two sheets. I need to count (all in the same column) in one case a number/text combo (EXE & 000). In the next case I need to count only text (from same column as above!). I am a novice & thought simply using the "COUNT" would do it but have been at it for about an hour & cannot figure it out!!! Please help! |
#3
|
|||
|
|||
The only text I need to count in the second scenario is "IBE".
"Trixie" wrote: I am working with a workbook that contains two sheets. I need to count (all in the same column) in one case a number/text combo (EXE & 000). In the next case I need to count only text (from same column as above!). I am a novice & thought simply using the "COUNT" would do it but have been at it for about an hour & cannot figure it out!!! Please help! |
#4
|
|||
|
|||
=COUNTIF(Range,"IBE")
-- Regards, Peo Sjoblom "Trixie" wrote in message ... The only text I need to count in the second scenario is "IBE". "Trixie" wrote: I am working with a workbook that contains two sheets. I need to count (all in the same column) in one case a number/text combo (EXE & 000). In the next case I need to count only text (from same column as above!). I am a novice & thought simply using the "COUNT" would do it but have been at it for about an hour & cannot figure it out!!! Please help! |
#5
|
|||
|
|||
Probably
=COUNTIF(Range,"*IBE*") -- HTH RP (remove nothere from the email address if mailing direct) "Peo Sjoblom" wrote in message ... =COUNTIF(Range,"IBE") -- Regards, Peo Sjoblom "Trixie" wrote in message ... The only text I need to count in the second scenario is "IBE". "Trixie" wrote: I am working with a workbook that contains two sheets. I need to count (all in the same column) in one case a number/text combo (EXE & 000). In the next case I need to count only text (from same column as above!). I am a novice & thought simply using the "COUNT" would do it but have been at it for about an hour & cannot figure it out!!! Please help! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
need to find which numbers (3+) in a column sum to a value | Excel Discussion (Misc queries) | |||
I cannot get a column of numbers to sum, why? | Excel Discussion (Misc queries) | |||
I cannot get a column of numbers to sum, why? | Excel Worksheet Functions | |||
Cannot get a column of numbers to SUM...why? | Excel Worksheet Functions | |||
Counting numbers in a column without including others | Excel Worksheet Functions |