G
Guest
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...
=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...