I have a workbook that consists of a sheet for every day plus a summary
sheet. Each daily sheet is a sign-in log where I enter names of people
who did not sign out a certain piece of equipment under an OPEN or CLOSE
column. I then enter each name on the summary sheet. I need a formula
that will search through all 31 daily sheets in only the OPEN and CLOSE
columans and count each time a name on the summary sheet appears.

I had a rather unweildy SUMPRODUCT formula that basically had an
argument for each individual page and which checked the entire sheet,
but altering it to only check certain columns would make it way too
long. And when I try to do it as a range of sheets ('1:31'!) I get a
VALUE error and it appears to be checking cells outside the range
(something like $BC$1) when I show the calculation steps.

Any help would be appreciated!


--
DailyRich
------------------------------------------------------------------------
DailyRich's Profile: http://www.excelforum.com/member.php...o&userid=30284
View this thread: http://www.excelforum.com/showthread...hreadid=499528