I am really stumped at why a sumif formula ALWAYS returns zero.
The basic formula is:
=sumif($a$5:$a20,"<=$b$1",$b5:$b25)*$c$1
Column A contains sequential dates
Cell B1 has a terminating date
Cells B5:B25 have values of mileage travelled on dates corresponding to column A
Cell C1 has a value at which those mileages should be valued
I have attached a sample Excel spreadsheet showing the layout.
Bookmarks