LinkBack URL
About LinkBacks
Hello all,
Using SUMIFS, the basic one criteria works correctly, but when I try to use a date range selector as criteria 2 and 3, if fails.
I cant work out why.
=SUMIFS(Data!H:H,Data!C:C,A2,Data!M:M, ">="&H1,Data!M:M, "<="&H2)
Thanks BVG
Hello all,
Using SUMIFS, the basic one criteria works correctly, but when I try to use a date range selector as criteria 2 and 3, if fails.
I cant work out why.
=SUMIFS(Data!H:H,Data!C:C,A2,Data!M:M, ">="&H1,Data!M:M, "<="&H2)
Thanks BVG
Last edited by Badvgood; 03-26-2020 at 04:09 PM.
The "dates" in column M are text not real dates. The best option would be to convert them to real dates
Thanks, I had checked this but may be incorrect. In column N, I used the formula =M1+1 to check this and the date increased by 1. Is this not a way of checking that dates are stored as dates?Originally Posted by Fluff13
Thanks BVG
Try this in N2 >> =ISNUMBER(M2)
You will get FALSE which means M2 is not a number
HTH
Regards, Jeff
Thanks Jeff, very useful to know. Can I ask what you think is the best way for me to convert all the 'dates' is to resolve my issue?
Thanks BVG
Try this
Convert Range of text to numbers
Data >> Data Tools >> Text to Columns
Highlight the range to convert >> All of column M
Next >> Next >> Date >> DMY >> Finish
Last edited by jeffreybrown; 03-26-2020 at 03:10 PM.
Best way to check dates is select the column & change the format to general, if you a number like 43861 it's a date, if you see 31/01/2020 it's text
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks