I need a formula that will look at the dates in a column and if between X and Y then sum(range)
I am working on calculating quarterly totals, so I want it to look in colA for date between 01/01/2019 and 03/31/2019 then add that range totals from column E
col A Col B c d e
<colgroup><col><col><col><col><col></colgroup><tbody>
</tbody>
I am working on calculating quarterly totals, so I want it to look in colA for date between 01/01/2019 and 03/31/2019 then add that range totals from column E
col A Col B c d e
Date week ending | Transaction Code | Gross pay | Vac Pay | Total Pay |
1/27/2019 | Regular | $ 3,150.00 | $ 126.00 | $3,276.00 |
2/3/2019 | Regular | $ 3,000.00 | $ 120.00 | $3,120.00 |
2/10/2019 | Regular | $ 3,000.00 | $ 120.00 | $3,120.00 |
2/17/2019 | Regular | $ 3,000.00 | $ 120.00 | $3,120.00 |
2/24/2019 | Stat Holiday Pay | $ 631.80 | $ 25.27 | $657.07 |
2/24/2019 | Regular | $ 2,550.00 | $ 102.00 | $2,652.00 |
3/3/2019 | Regular | $ 3,225.00 | $ 129.00 | $3,354.00 |
3/10/2019 | Expense Reimbursement | $ 535.53 | ||
3/10/2019 | Regular | $ 3,300.00 | $ 132.00 | $3,432.00 |
3/10/2019 | Overtime | $ 787.50 | $ 31.50 | $819.00 |
3/17/2019 | Regular | $ 3,300.00 | $ 132.00 | $3,432.00 |
3/24/2019 | Regular | $ 3,300.00 | $ 132.00 | $3,432.00 |
3/31/2019 | Overtime | $ 787.50 | $ 31.50 | $819.00 |
3/31/2019 | Expense Reimbursement | $ 241.75 | ||
3/31/2019 | Regular | $ 3,300.00 | $ 132.00 | $3,432.00 |
4/7/2019 | Regular | $ 3,300.00 | $ 132.00 | $3,432.00 |
4/14/2019 | Regular | $ 3,300.00 | $ 132.00 | $3,432.00 |
4/21/2019 | Regular | $ 2,850.00 | $ 114.00 | $2,964.00 |
4/21/2019 | Stat Holiday Pay | $ 687.98 | $ 27.52 | $715.50 |
4/28/2019 | Regular | $ 3,300.00 | $ 132.00 | $3,432.00 |
5/5/2019 | Regular | $ 3,300.00 | $ 132.00 | $3,432.00 |
5/12/2019 | Regular | $ 3,300.00 | $ 132.00 | $3,432.00 |
5/19/2019 | Regular | $ 3,300.00 | $ 132.00 | $3,432.00 |
5/26/2019 | Regular | $ 2,700.00 | $ 108.00 | $2,808.00 |
5/26/2019 | Stat Holiday Pay | $ 686.40 | $ 27.46 | $713.86 |
6/2/2019 | Regular | $ 3,300.00 | $ 132.00 | $3,432.00 |
6/9/2019 | Regular | $ 3,300.00 | $ 132.00 | $3,432.00 |
6/16/2019 | Regular | $ 3,300.00 | $ 132.00 | $3,432.00 |
6/23/2019 | Overtime | $ 787.50 | $ 31.50 | $819.00 |
<colgroup><col><col><col><col><col></colgroup><tbody>
</tbody>