To count specific numbers on a seperate tab. 1

[Snooker07]

I have a spreadsheet with two tabs, the first tab (called "Master Lost") has a row with numbers in it like 100,200,300...

The next tab (Called "Summary")I want to be able to count all cells that have a 200 in it from the "Master Lost" tab. ( I do not want to add the numbers...I just want to know how many cells have 100 or 200 etc.. in it.

This sounds easy but I can not seem to figure this one out.
Any help would be appreciated.
Thank you.
Snooker07

 

[SkipVought]

Hi,

Check out the COUNTIF function.

Skip,
^{Don't let the Diatribe...
talk you to death!}
_{Just traded in my old subtlety...
for a NUANCE!}