Thanks Luke,

Is there a similar formula that will sum the dollar amounts in column P if
the date in column A is 4/1/2010. Can you help with that too?

Desireé

"Luke M" wrote:

Select all your sheets that have data (Use Shift and/or Ctrl)
In an unused cell (say Z1) input:
=SUMPRODUCT(--(D6:D1000="x"),--(A6:A1000=DATEVALUE("4/1/2010")))

This will place this formula in all the data sheets. On your summary sheet,
input something like:
=SUM('Sheet 1:Sheet 5'!Z1)

This is a 3D formula.

--
Best Regards,

Luke M
"Dhardy" wrote in message
...
Good Morning,

I am working on a stat log that needs to provide daily, weekly and monthly
totals for each staff member.

I need excel to count the # of "x" in D6:D1000 (for each worksheet) if the
date in A6:A1000 is 4/1/2010.

I have tried several different functions/formulas and I have not received
the response I am looking for.

Thanks in advance for your help!
Desireé


.