I've searched for an answer and haven't been able to find one. I have two worksheets, one with date column and numerical data (CW12), the other with two date ranges (Summary). I am trying to enter my date range on one sheet and total the amount from the other sheets data. Specifically, I want to find how many mile a given vehicle travels between the two dates. (quarterly)
The formula I have returns either #value or #ref when modified. The formula I am entering is
I am new to the forum so if I didn't pose the question properly please forgive me and help me to solve what should be pretty easy, I just can't see what I am missing.
Bookmarks