steve400243
Active Member
- Joined
- Sep 15, 2016
- Messages
- 429
- Office Version
- 365
- 2016
- Platform
- Windows
Hello, I am trying to get this formula to sum the total as needed between the start date and end date.
Sheet1A6 is the start Date, Sheet1A8 is the end date.
Column 15, Sheet2 is the date data was entered, column3, sheet2 is the amount to sum.
Here is what I have so far.
=SUMIF(Table1[Column15],Sheet1!A6,Sheet1!A8,Table1[Column3])
Thanks for your help in advance.
Sheet1A6 is the start Date, Sheet1A8 is the end date.
Column 15, Sheet2 is the date data was entered, column3, sheet2 is the amount to sum.
Here is what I have so far.
=SUMIF(Table1[Column15],Sheet1!A6,Sheet1!A8,Table1[Column3])
Thanks for your help in advance.