richmcgill
Board Regular
- Joined
- Feb 4, 2019
- Messages
- 87
- Office Version
- 2016
- Platform
- Windows
I am needing three formulas to help counting dates
[TABLE="width: 840"]
<colgroup><col width="760" style="width: 570pt; mso-width-source: userset; mso-width-alt: 27794;"> <col width="360" style="width: 270pt;"> <tbody>[TR]
[TD="width: 1120, bgcolor: transparent, colspan: 2"]
The number of dates / rows shrinks and grows daily and there is a lot of other information above and below the dates that are being counted so that information needs to stay in tact.
The date in cell A2 is a fixed date and not a Today formula
1. Count All Dates that IS equal to the date in A2 and has any amount in the "Amount" column
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, colspan: 2"]2. Count All Dates that are NOT equal to the date in A2 and has any amount in the "Amount" column
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, colspan: 2"]3. Count All Dates on that are NOT equal to the date in A2 and has an amount of $0.00 in the "Amount" column
[/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="width: 93"]
<colgroup><col width="66" style="width: 50pt; mso-width-source: userset; mso-width-alt: 2413;"> <col width="57" style="width: 43pt; mso-width-source: userset; mso-width-alt: 2084;"> <tbody>[TR]
[TD="width: 66, bgcolor: transparent"]Date[/TD]
[TD="width: 57, bgcolor: transparent"]Amount[/TD]
[/TR]
[TR]
[TD="width: 66, bgcolor: transparent"]5/20/2019[/TD]
[TD="width: 57, bgcolor: transparent"]$3.90 [/TD]
[/TR]
[TR]
[TD="width: 66, bgcolor: transparent"]3/1/2019[/TD]
[TD="width: 57, bgcolor: transparent"]$81.65 [/TD]
[/TR]
[TR]
[TD="width: 66, bgcolor: transparent"]4/15/2019[/TD]
[TD="width: 57, bgcolor: transparent"]$985.00
[/TD]
[/TR]
[TR]
[TD="width: 66, bgcolor: transparent"]5/24/2019[/TD]
[TD="width: 57, bgcolor: transparent"]$168.84
[/TD]
[/TR]
[TR]
[TD="width: 66, bgcolor: transparent"]5/29/2019[/TD]
[TD="width: 57, bgcolor: transparent"]$0.00
[/TD]
[/TR]
[TR]
[TD="width: 66, bgcolor: transparent"]5/30/2019[/TD]
[TD="width: 57, bgcolor: transparent"]$181.90
[/TD]
[/TR]
[TR]
[TD="width: 66, bgcolor: transparent"]6/7/2019[/TD]
[TD="width: 57, bgcolor: transparent"]$0.32
[/TD]
[/TR]
[TR]
[TD="width: 66, bgcolor: transparent"]5/30/2019[/TD]
[TD="width: 57, bgcolor: transparent"]$40.16
[/TD]
[/TR]
[TR]
[TD="width: 66, bgcolor: transparent"]6/3/2019[/TD]
[TD="width: 57, bgcolor: transparent"]$560.96 [/TD]
[/TR]
</tbody>[/TABLE]
Could look like this
1. 9
2. 13
3. 12
34
[TABLE="width: 840"]
<colgroup><col width="760" style="width: 570pt; mso-width-source: userset; mso-width-alt: 27794;"> <col width="360" style="width: 270pt;"> <tbody>[TR]
[TD="width: 1120, bgcolor: transparent, colspan: 2"]
The number of dates / rows shrinks and grows daily and there is a lot of other information above and below the dates that are being counted so that information needs to stay in tact.
The date in cell A2 is a fixed date and not a Today formula
1. Count All Dates that IS equal to the date in A2 and has any amount in the "Amount" column
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, colspan: 2"]2. Count All Dates that are NOT equal to the date in A2 and has any amount in the "Amount" column
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, colspan: 2"]3. Count All Dates on that are NOT equal to the date in A2 and has an amount of $0.00 in the "Amount" column
[/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="width: 93"]
<colgroup><col width="66" style="width: 50pt; mso-width-source: userset; mso-width-alt: 2413;"> <col width="57" style="width: 43pt; mso-width-source: userset; mso-width-alt: 2084;"> <tbody>[TR]
[TD="width: 66, bgcolor: transparent"]Date[/TD]
[TD="width: 57, bgcolor: transparent"]Amount[/TD]
[/TR]
[TR]
[TD="width: 66, bgcolor: transparent"]5/20/2019[/TD]
[TD="width: 57, bgcolor: transparent"]$3.90 [/TD]
[/TR]
[TR]
[TD="width: 66, bgcolor: transparent"]3/1/2019[/TD]
[TD="width: 57, bgcolor: transparent"]$81.65 [/TD]
[/TR]
[TR]
[TD="width: 66, bgcolor: transparent"]4/15/2019[/TD]
[TD="width: 57, bgcolor: transparent"]$985.00
[/TD]
[/TR]
[TR]
[TD="width: 66, bgcolor: transparent"]5/24/2019[/TD]
[TD="width: 57, bgcolor: transparent"]$168.84
[/TD]
[/TR]
[TR]
[TD="width: 66, bgcolor: transparent"]5/29/2019[/TD]
[TD="width: 57, bgcolor: transparent"]$0.00
[/TD]
[/TR]
[TR]
[TD="width: 66, bgcolor: transparent"]5/30/2019[/TD]
[TD="width: 57, bgcolor: transparent"]$181.90
[/TD]
[/TR]
[TR]
[TD="width: 66, bgcolor: transparent"]6/7/2019[/TD]
[TD="width: 57, bgcolor: transparent"]$0.32
[/TD]
[/TR]
[TR]
[TD="width: 66, bgcolor: transparent"]5/30/2019[/TD]
[TD="width: 57, bgcolor: transparent"]$40.16
[/TD]
[/TR]
[TR]
[TD="width: 66, bgcolor: transparent"]6/3/2019[/TD]
[TD="width: 57, bgcolor: transparent"]$560.96 [/TD]
[/TR]
</tbody>[/TABLE]
Could look like this
1. 9
2. 13
3. 12
34