One way:

="Sheet 1 has " & COUNTIF(Sheet1!1:65536,"<0") & " neg. numbers"
="Sheet 2 has " & COUNTIF(Sheet2!1:65536,"<0") & " neg. numbers"
....


In article ,
banchee wrote:

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/