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