Hi
maybe a linebreak as I only copied your sheet references. Just use your
existing formula but with the dATE function included
--
Regards
Frank Kabel
Frankfurt, Germany
"Carole O" schrieb im Newsbeitrag
...
Hi, Frank
I copied and pasted your suggestion and get a #REF. When I trace the
error,
it shows a small table (Shift 1?) with an arrow pointing to the #REF
cell.
Any ideas?
Carole O
"Frank Kabel" wrote:
Hi
try:
=SUMPRODUCT(--('SHIFT 1'!$B$2:$B$200="2-MAKE READY")*('SHIFT
1'!$C$2:$C$200=DATE(2004,10,4)))
--
Regards
Frank Kabel
Frankfurt, Germany
"Carole O" schrieb im
Newsbeitrag
...
Excel 2003
I have two spreadsheets within a workbook (Shift 1 and Daily
Worksheet). I
want to capture each category (i.e. 2-MAKE READY)in Shift 1
spreadsheet for
each day of the month. The formula is in the Daily Worksheet
which
has the
categories in column a, and columns b - z have the day of the
month
(i.e.10/4/04) and this is where I have the formula:
=SUMPRODUCT(--('SHIFT 1'!$B$2:$B$200="2-MAKE READY")*('SHIFT
1'!$C$2:$C$200=10/4/2004)). This isn't working. I can get the
total
of all
2-MAKE READY for the month by eliminating everything from *on,
but I
can't
get it to match and count on the date.
What I'd really like {: -) is to look up the 2-MAKE READY in the
SHIFT 1 and
count if the date = b1,c1 (10/1, 10/2) cells in the Daily
Worksheet.
I hope this makes sense!
TIA,
Carole O
|