Calculate how many times member A visit the cafe
Closed
jeff
-
Apr 26, 2018 at 09:00 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Contributor Last seen December 27, 2022 - Apr 26, 2018 at 11:46 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Contributor Last seen December 27, 2022 - Apr 26, 2018 at 11:46 AM
Related:
- Calculate how many times member A visit the cafe
- Internet cafe simulator 2 pc download - Download - Simulation
- How to calculate vat in excel - Guide
- How to calculate position in excel ✓ - Excel Forum
- How to calculate bece aggregate - Excel Forum
- Internet cafe simulator download - Download - Simulation
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Contributor
Last seen
December 27, 2022
555
Apr 26, 2018 at 11:46 AM
Apr 26, 2018 at 11:46 AM
Hi Jeff,
Not sure how you want the end result to look like, but the following formula will count the number of times your table of dates, contains dates higher then a given data:
=COUNTIF($A$1:$A1,">="&$E$1)
Where A1:A6 is the table of dates and E1 is the specified date (or replace it with an actual date instead of cell reference). In this example place the formula in B1 and drag it down.
To color the cell, use conditional formatting. When you want to color the cell red when the above formula is placed in column B and gives a result of 5, then:
- Select column B.
- Go to conditional formatting, found under the Start ribbon and select add rule.
- Choose to use a formula: =$B1=5, choose your Format.
- Hit OK when done.
Best regards,
Trowa
Not sure how you want the end result to look like, but the following formula will count the number of times your table of dates, contains dates higher then a given data:
=COUNTIF($A$1:$A1,">="&$E$1)
Where A1:A6 is the table of dates and E1 is the specified date (or replace it with an actual date instead of cell reference). In this example place the formula in B1 and drag it down.
To color the cell, use conditional formatting. When you want to color the cell red when the above formula is placed in column B and gives a result of 5, then:
- Select column B.
- Go to conditional formatting, found under the Start ribbon and select add rule.
- Choose to use a formula: =$B1=5, choose your Format.
- Hit OK when done.
Best regards,
Trowa
