Ok......

Make a list of the sheet names that you want to include in the formula:

H1 = Sheet2
H2 = Sheet3
H3 = Sheet4
H4 = Sheet5

=IF(SUMPRODUCT(COUNTIF(INDIRECT("'"&H$1:H$4&"'!A:A "),A1)),"Same","New to
report")

Is there something wrong with the sheet1, sheet2, etc..reference names?

No, not at all! Sometimes you can "build" the references to sheets that have
a sequential naming convention without having to dedicate a range to list
them. (but I wouldn't do it in this case)

I reference the entire A column because sometimes there may be more or
less items in that column

Ok, that's fine. But sometimes you might have to make your file as efficient
as possible and referencing large unused portions can cause things to slow
down.

Biff

"ChrisPrather"
wrote in message
news:ChrisPrather.2cwsbi_1156195212.4755@excelforu m-nospam.com...

There could be as few as three worksheets or as many as I feel
necessary. It is completely possible that another function may work
better and I wouldn't know because I'm pretty new at this.

Is there something wrong with the sheet1, sheet2, etc.. reference
names? I know they are vanilla, but I don't really mind at this point.
If I could figure out how to reference more than 1 worksheet in a
formula, I would probably change the name of the worksheets to reflect
the date of the data. = )

I reference the entire A column because sometimes there may be more or
less items in that column and I don't really want to have to change the
range each time. Seaching A:A covers any number of items and empty cells
are ignored so it seems to work.

I would totally agree that I may be using a less than efficient formula
due to not knowing better. I really appreciate your help though Biff.


--
ChrisPrather
------------------------------------------------------------------------
ChrisPrather's Profile:
http://www.excelforum.com/member.php...o&userid=37743
View this thread: http://www.excelforum.com/showthread...hreadid=573836