=countif(Sheet1!A1:Z5000,"<0")

change the A1:Z5000 to reflect the range you expect to contain information.

If you want text with it

="Sheet1 has " & countif(Sheet1!A1:Z5000,"<0") & " neg. numbers"

if you want all five sheets reported in 1 cell, then concatenate

="Sheet1 has " & countif(Sheet1!A1:Z5000,"<0") & " neg. numbers" & ", Sheet2
has " & countif(Sheet2!A1:Z5000,"<0") & " neg. numbers"

--
Regards,
Tom Ogilvy

"banchee" wrote in message
...
I am currently working on a project that has 5 sheets, each sheet is the
same format. I am wanting to create a sheet that will look at each of
the 5 sheets and tell me how many negative numbers are on each sheet.
For example: I want it to tell me: Sheet 1 has 5 neg. numbers, Sheet
2 has 3 neg. #'s, so on. Any help would be GREATLY APPRECIATED!!
thanks for your time.

Kyle



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/