Advice Please
what function do I used to have excel search through columns and show how
many times the number I want appears? |
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? . |
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? |
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? |
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? . |
Replace semicolons with commas!
Arvi Laanemets |
All times are GMT +1. The time now is 04:13 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com