Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Advice Please
what function do I used to have excel search through columns and show how
many times the number I want appears? |
#2
|
|||
|
|||
Use COUNTIF. For example, to count the no. of times 8
appears in columns A-C: =COUNTIF(A:C,8) Of course this only counts cells with 8. Cells such as 88 would be ignored. HTH Jason Atlanta, GA -----Original Message----- what function do I used to have excel search through columns and show how many times the number I want appears? . |
#3
|
|||
|
|||
If you wanted to search through Column A, try this:
=COUNTIF(A:A,25) If 25 was the number you were looking to count. -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Greg B" wrote in message ... what function do I used to have excel search through columns and show how many times the number I want appears? |
#4
|
|||
|
|||
Greg
=COUNTIF(A1:D100,123) Your number being 123 Gord Dibben Excel MVP On Thu, 17 Mar 2005 15:59:17 +1030, "Greg B" wrote: what function do I used to have excel search through columns and show how many times the number I want appears? |
#5
|
|||
|
|||
Hi
To count all occurrences of some number in range, like 18 22 180 .... , which contains three number 8's, you can use an array formula (entered with Ctrl+Alt+Enter) like: =SUM(LEN(A1:A100)-LEN(SUBSTITUTE(A1:A100;8;""))) -- When sending mail, use address arvil<attarkon.ee Arvi Laanemets "Jason Morin" wrote in message ... Use COUNTIF. For example, to count the no. of times 8 appears in columns A-C: =COUNTIF(A:C,8) Of course this only counts cells with 8. Cells such as 88 would be ignored. HTH Jason Atlanta, GA -----Original Message----- what function do I used to have excel search through columns and show how many times the number I want appears? . |
#6
|
|||
|
|||
Replace semicolons with commas!
Arvi Laanemets |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula Advice Needed | Excel Discussion (Misc queries) | |||
Almost got it !! but need advice | Excel Worksheet Functions | |||
Advice please | New Users to Excel | |||
building invoice - strategy advice | Excel Discussion (Misc queries) | |||
need an advice in excel sheets.... | Excel Discussion (Misc queries) |