That works fine. Maybe layout the data for us and tell us what you do get. I
assume that J65 holds 1st April.


--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"soconfused" wrote in message
...
I have a worksheet that has 6 colums of dates and then 6 colums of numbers.
I am trying to say take the 6 columns of dates if they are < or = to
4/1/2006
add all the numbers in the other six columns.
I tried:
=SUMIF(F44:K51,"<"&J65,T44:Y51), F44:K51= DATES FROM 4/28/06 THROUGH
1/12/2007 J65=4/1/2006 T44:Y51=NUMBER VALUES.

If I understand this correctly, I have two dates in the "Date Range" that
are 4/4/06 and 4/28/06 so it should pick up the numerical values 1 and 1 =
2,
but I'm not getting that answer.

Any and all help will be appreciated

Thanks
--
DMM