Forum Discussion
Dates as numbers in formulas?
I use a spreadsheet to calculate fuel cost/economy and usage over the course of the year. Individual columns show date (in date format), fuel cost, mileage, etc. Then by simple division or multipli...
Your other formula should look like this:
=SUMIFS($E$1:$E$149,
$A$1:$A$149,">="&$B$152,
$A$1:$A$149,"<"&$B$153)
=SUMIFS($E$1:$E$149,
$A$1:$A$149,">="&$B$152,
$A$1:$A$149,"<"&$B$153)
Twifoo Sorry that I did not respond sooner. Just got the opportunity to see your solution and enter into my formula. And it works! Thanks. If I can ask another question, just what does the '&' represent (for future reference)?
Again, thanks for the help.
- The ampersand (&) joins the comparative operator and the range reference.
