Thanks for the feedback, Helen

Trust you've got it sorted out by now with Bob's help

Just some comments:

=SUMPRODUCT(--(YEAR(Log!B3:B80)=1997),--(Log!E3:E80=17))

I've tried the change you suggested -- adding YEAR
-- and end up with a result of #VALUE! ..

Think some/all of the data in Log!B3:B80
may not be real dates/numbers
(dates are actually numbers in Excel)

(All it needs is a single cell in B3:B80 which
is not a real date, and you'll get #VALUE! <g)

Try this quick check in the sheet Log
in an empty col to the right

Put a label into G2: Check (say)

Put in G3: =ISNUMBER(B3+0)
Copy down to G80

[G3:G80 should evaluate to TRUE
for real dates/numbers]

Select G2:G80
Do a Data Filter Autofilter on the range
Click on FALSE in the droplist in G2 to filter these out
Look at what's in col B and try re-entering the date(s)

--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----