jblack6572
03-10-2014, 09:37 AM
11380
I'm trying to use sumifs to pull a number if it is less than a certain date. I've got the criteria set up as "<"&"Cell Reference". All my numbers are formatted as dates but it still doesn't seem to work. Any ideas on what I'm doing wrong?
Spreadsheet attached.
I'm trying to use sumifs to pull a number if it is less than a certain date. I've got the criteria set up as "<"&"Cell Reference". All my numbers are formatted as dates but it still doesn't seem to work. Any ideas on what I'm doing wrong?
Spreadsheet attached.