Home |
Search |
Today's Posts |
#1
|
|||
|
|||
count if
I need to count cells -than content text not numbers- with a defined
condition but the cells are not follow (not a range or cells). What function/s can I use? |
#2
|
|||
|
|||
you can use the countif function
for example if you have .........A..............B 1.....cat..........dog 2....mouse.....cat 3.....cat........cat and want to count all the cats in A1:B3 the formula would be =COUNTIF(A1:B3,"cat") -- Cheers JulieD check out www.hcts.net.au/tipsandtricks.htm ....well i'm working on it anyway "Help with count if" <Help with count wrote in message ... I need to count cells -than content text not numbers- with a defined condition but the cells are not follow (not a range or cells). What function/s can I use? |
#3
|
|||
|
|||
THANKS FOR THE ANSWER!
IT TOTALLY WORKED!! "JulieD" wrote: you can use the countif function for example if you have .........A..............B 1.....cat..........dog 2....mouse.....cat 3.....cat........cat and want to count all the cats in A1:B3 the formula would be =COUNTIF(A1:B3,"cat") -- Cheers JulieD check out www.hcts.net.au/tipsandtricks.htm ....well i'm working on it anyway "Help with count if" <Help with count wrote in message ... I need to count cells -than content text not numbers- with a defined condition but the cells are not follow (not a range or cells). What function/s can I use? |
#4
|
|||
|
|||
you're welcome and thanks for the feedback
"thanks" wrote in message ... THANKS FOR THE ANSWER! IT TOTALLY WORKED!! "JulieD" wrote: you can use the countif function for example if you have .........A..............B 1.....cat..........dog 2....mouse.....cat 3.....cat........cat and want to count all the cats in A1:B3 the formula would be =COUNTIF(A1:B3,"cat") -- Cheers JulieD check out www.hcts.net.au/tipsandtricks.htm ....well i'm working on it anyway "Help with count if" <Help with count wrote in message ... I need to count cells -than content text not numbers- with a defined condition but the cells are not follow (not a range or cells). What function/s can I use? |
#5
|
|||
|
|||
It depends on how many cells you want to count, If is less than 30 use
=count(a1,a3,a5,c4,t8,...) if it is more than 30 select the cells using th control key go to <insert<Name<define and give a unique name to the group (for example "rover" then use =count(rover) I do not know how many cells can be named in a group, you may have to use several names of groups to get up to your total requirements =count(rover,spot,reX) "Help with count if" wrote: I need to count cells -than content text not numbers- with a defined condition but the cells are not follow (not a range or cells). What function/s can I use? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Filter Count of Records Retrieved. | Excel Discussion (Misc queries) | |||
SUMPRODUCT Formula to Count Row of data Below Matched Criteria | Excel Worksheet Functions | |||
Count number to reach a cumulative value | Excel Worksheet Functions | |||
Count If Formula | Excel Worksheet Functions | |||
count based on two fields - need quickly | Excel Worksheet Functions |