Forum Discussion
SUMIFS Function Returning Value of First Occurrence Only Instead of Summing All
Thanks Riny_van_Eekelen , unfortunately, the data is too sensitive to attach a file.
However, I worked out what the problem was. My Dates had 'days added' to them. I thought they were whole integer days but they were derived from an average of days, which returned a decimal.
I was formatting this date as 'short date', which masked the fact that it was now a datetime. Hence the lookup failed unless it was a perfect intiger.
TimJackson A file perhaps, demonstrating the formula not working. Attach it to your post or share a link to the file Onedrive (or similar) giving unrestricted access.
Thanks Riny_van_Eekelen , unfortunately, the data is too sensitive to attach a file.
However, I worked out what the problem was. My Dates had 'days added' to them. I thought they were whole integer days but they were derived from an average of days, which returned a decimal.
I was formatting this date as 'short date', which masked the fact that it was now a datetime. Hence the lookup failed unless it was a perfect intiger.