using a date in criteria for SUMIF
 

I have a cell with the following formula:
=SUMIF(CALC!A$2:A$52,"=03/01/07",CALC!O$2:O$52)

So it is currently searching the Range CALC!A$2:A$52 for records with
"=03/01/07"
How can I ask it to search for records with a matching date... for example I
have the above formula in a cell B3 that is just to the Right of a Col with
entry formatted as a date (ex: 03/01/07 is in Cell A3) I want to be able to
copy the above formula down and have it reference in the neighboring date to
the Left...

thanks and if you need clarification i could probably explain this better...

using a date in criteria for SUMIF
 

With the date in A3 and the formula in B3:
=SUMIF(CALC!A$2:A$52,a3,CALC!O$2:O$52)




Will wrote:

I have a cell with the following formula:
=SUMIF(CALC!A$2:A$52,"=03/01/07",CALC!O$2:O$52)

So it is currently searching the Range CALC!A$2:A$52 for records with
"=03/01/07"
How can I ask it to search for records with a matching date... for example I
have the above formula in a cell B3 that is just to the Right of a Col with
entry formatted as a date (ex: 03/01/07 is in Cell A3) I want to be able to
copy the above formula down and have it reference in the neighboring date to
the Left...

thanks and if you need clarification i could probably explain this better...

--

Dave Peterson