OK jeff,

for future reference....

that formula SHOULD work as long as you have dates in A7:A372 and a date in
A5 then the format shouldn't matter. Without referencing a cell you could
just use

=SUMIF(A7:A372,""&TODAY(),B7:B372)

If this still doesn't work then it may be because your numbers in column C
are, in fact, text.

What do you get using a formula like

=ISNUMBER(B7)?

If this gives FALSE then you probably need to convert column B to numeric.
You can do this by selecting the column and using

Data Text to Columns Finish

" wrote:

Hi

Yes I realised I'd got the cell reference wrong after posting. However
I've tried the ""&A5 changing the incorrect ref, but still get zero.
A5 is todays date as a number. I've tried the date as 05 Nov 06 format
the same as the column of data i'm looking for, but still no luck.

However I woke up this morning and realised I can use an IF + AND
statement in an adjacent column

eg =IF(AND($A7$A$3,C7=1),1,0)

& then sum this column instead. I'll just hide this column. (A3 has the
cell with TODAY as the same format as the cells below. It doesn't work
with "todays" date formatted as a number and the rest of the dates as
05 Nov 06 format. Strange.

Thanks anyway dll. I'm sure there must be a way but I've got to get
this finished by tomorrow.

Jeff