PDA

View Full Version : Sumifs and dates



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.

Bob Phillips
03-10-2014, 11:21 AM
The dates in the summary sheet are text, you need to transform them to dates (Data>Text To Columns).