Sample.xlsm
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.
The dates in the summary sheet are text, you need to transform them to dates (Data>Text To Columns).
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber
Posting Permissions
Reply With Quote
