Hi there,
I'm using the following formula to sum between a date range:
=sumifs(Services!$O:$O,Services!$A:$A,">="&$C$50,Services!$A:$A,"<="&$C$51)
The date range I'm summing between is 1/1/15 to 3/31/15 to see how much money was made for the quarter. However, the formula is not including the day of 3/31/15 for some reason, it only goes from 1/1/15 to 3/30/15.
Any ideas?
Thank you!
may be some problem with date or date format or leading and unnecessary spaces for 3/31/15
please attach sample file where it is giving wrong answer, delete sensitive data if any
Samba
Say thanks to those who have helped you by clicking Add Reputation star.
Sample Spreadsheet-2.xlsx
Thanks for the help, the formula in question is found on the "Stats" tab.
Last edited by TylerJamison; 04-04-2015 at 04:26 PM.
31-03-2015 11:59:59 PM
try this in C3 IN STAT SHEET
Ahhhh, that worked! So it was using 3/31/15 12:00:01 AM as a starting point. Thank you!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks