LinkBack URL
About LinkBacks
I maintain a big database from Jan 1 2012. I need to enter daily work orders into the database.Suppose i want to retrieve a specific Month data I am not able to do by using a formula. Please help me in this regard.
I maintain a big database from Jan 1 2012. I need to enter daily work orders into the database.Suppose i want to retrieve a specific Month data I am not able to do by using a formula. Please help me in this regard.
You get better help if you post an Excel-file (example of your workbook), without confidential information.
Make sure the workbook demonstrates your desired results if possible, or just highlight the cells you're trying to fix.
Use BEFORE/AFTER sheets if that helps make it clearer.
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
This worked in a test sheet:
=SUMIFS(Sales,Dates,">="&Start,Dates,"<="&End)
Sales is the column that contains all the sales data
Dates is the column that contains all the dates
Start = the start date
End = the end date
Dave
I'm no expert I just like solving problems
I would suggest an pivot table.
Try advance filter with criteria from start date to end date.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks