Donate SIGN UP
Home > Technology > Computers > Excel Formula's

Excel Formula's

Avatar Image
JessW | 01:38 Mon 27th Oct 2008 | Computers
3 Answers
If I have a spreadsheet with a list of numbers that may be repeated many times down the column, is there a formula that can count how many times that particular number is listed?
prev DOS emulator
  
next XP update?
Gravatar

Answers

1 to 3 of 3rss feed

Best Answer

No best answer has yet been selected by JessW. Once a best answer has been selected, it will be shown here.

For more on marking an answer as the "Best Answer", please visit our FAQ.
Avatar Image ChuckFickens
=COUNTIF(A1:A100, 999)

Would count all occurrences of the number 999 in column a from a1 though to a100

01:42 Mon 27th Oct 2008
Avatar Image ACtheTROLL
sorry chuck - picky picky

if you use
=COUNTIF(A1:A100,d1)

you can just enter a search value - same thing really
01:51 Mon 27th Oct 2008
-- answer removed --

1 to 3 of 3rss feed

Do you know the answer?

Excel Formula's

Answer Question >>