if then statment

[Turwin]

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

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>

 

[Joe4]

Welcome to the Board!

You can use SUMIFS to do that.
See here for details on how to do that with a date range: https://exceljet.net/formula/sum-if-date-is-between

 

[Turwin]

Welcome to the Board!

You can use SUMIFS to do that.
See here for details on how to do that with a date range: https://exceljet.net/formula/sum-if-date-is-between

I tried them so now I used conditional formatting on the date column, is there one that looks at the conditional formatting colors?

If in Column A dates are green then add range in column D

 

[Joe4]

Conditional Formatting can only run off of values, not off of other formatting.
If the dates in column A are turned green by Conditional Formatting, you should just be able to use the same conditions that turned them green.

 

[Turwin]

Conditional Formatting can only run off of values, not off of other formatting.
If the dates in column A are turned green by Conditional Formatting, you should just be able to use the same conditions that turned them green.

how would I do date range in the formula? =sumifs(H:H,D:D,"1/1/2019:3/31/2019")

 

[Joe4]

Did you take a look at the link I provided in my first reply?
Here is one that might be a little better, as they hard-code the dates right in the formula (instead of using cell references that hold the dates).
https://www.spreadsheetweb.com/how-to-sum-values-between-two-dates/
You should be able to set yours up exactly the same way, so just follow that model.