Hello, I am trying to use SUMIFs with multiple criteria and a date range to return the sum using two excel sheets. I keep getting zero as my result... I made the fake charts below for help
Excel One - looking up units from excel two
=IFSUMS([Excel 2]$C$2:$C$5,[Excel 2]$A2:$A5,[Excel 1]$A2,[Excel 2]$B2:$B5,">="&[Excel 1]B$2,[Excel 2]$B2:$B5,"<="&[Excel 1]C$2)
Excel 2
Excel One - looking up units from excel two
=IFSUMS([Excel 2]$C$2:$C$5,[Excel 2]$A2:$A5,[Excel 1]$A2,[Excel 2]$B2:$B5,">="&[Excel 1]B$2,[Excel 2]$B2:$B5,"<="&[Excel 1]C$2)
Item | Start | End | Units |
A | 1/02/2020 | 1/07/2020 | |
B | 1/08/2020 | 1/14/2020 | |
C | 1/02/2020 | 1/07/2020 |
Excel 2
Item | Invoice Date | Units |
A | 1/05/2020 | 10 |
B | 1/09/2020 | 15 |
A | 1/07/2020 | 20 |
C | 1/03/2020 | 20 |