How to sum from two tables based on From-To Date criteria
Requirement:
The user has two spreadsheets that are in two tables. In each tab is same table format. And here is the problem...
Each table has date and data column.
I need a formula to sum values between two dates where the first date is the oldest date that I dont want to enter (so it must to be in formula) and date that the user inputs manually.
Solution:
=SUMIF(SData1718[Date],"<=" & E2,SData1718[Visitors])+SUMIF(SData1617[Date],"<="&E2,SData1617[Visitors])
Obtained from the OzGrid Help Forum.
Solution provided by NBVC.
See also: Index to Excel VBA Code and Index to Excel Freebies and Lesson 1 - Excel Fundamentals and Index to how to… providing a range of solutions and Index to new resources and reference sheets
See also:
| How to drag every Nth column, with varying starting column by date |
| How to use a VBA code to change cells colours based on date in other cells |
| How to count non blanks 5 years from the last non blank date |
| How to use SUMPRODUCT with dates |
| How to sum up values in a date range |
Click here to visit our Free 24/7 Excel/VBA Help Forum where there are thousands of posts you can get information from, or you can join the Forum and post your own questions.
Gallery
