How to sum from two tables based on From-To Date criteria

< Back to Search results

 Category: [Excel]  Demo Available 

How to sum from two tables based on From-To Date criteria




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.




=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.


stars (0 Reviews)