sumif not recognising dates properly?

I found something in the behaviour of a large spreadsheet  which puzzled me.  After much head scratching I eventually isolated and simplified the problem table and wonder if anyone can tell me what is going on.


Hopefully the  details below are fairly self explanatory. Total values in the last three footer lines should (I think) all be the same ($35)  but the two which depend on a date are incorrect - they seem to include value  for the 31 jan 22 date. Why?


The cells in invoice column are formatted as dates.  




D10:      SUMIF($Date of Invoice,">"&$B$10,Total)
D11:      SUMIFS(Total,Date of Invoice,">"&B$11)
D12:      SUMIFS(Total,Misc,"=1")

MacBook Pro 15″, macOS 10.14

Posted on Oct 26, 2022 6:57 PM

Reply
Question marked as Top-ranking reply

Posted on Oct 27, 2022 1:47 AM

You are so right! It was 2122. Many thanks. I'm guessing that at some point the date from previous December 2021 line was edited incorrectly into january line.

2 replies

This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

sumif not recognising dates properly?

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.