Forum Discussion
how to sum different number within dates range ?
nalnofal Many of the dates in the Total Sales table are in fact texts that look like dates. That's why they do not meet the criteria set in the SUMIFS formula. You can check that using the ISNUMBER function. change the text dates to real dates an it will work.
Select all dates. On the Data ribbon select Text to columns and just press Finish without changing any of the settings. Done that in the attached file.
nalnofal Many of the dates in the Total Sales table are in fact texts that look like dates. That's why they do not meet the criteria set in the SUMIFS formula. You can check that using the ISNUMBER function. change the text dates to real dates an it will work.
Select all dates. On the Data ribbon select Text to columns and just press Finish without changing any of the settings. Done that in the attached file.
Thank you very much Riny_van_Eekelen
your solution is very helpful , i review my original Data and i find many dates value is text even i change the format to dates .
So that the issue not in my formula and all my calculation was perfect.
I will keep in mind to use ISNUMBER function for all my dates value.