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 Moderator Last seen December 27, 2022 - Apr 26, 2018 at 11:46 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator 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
- Internet cafe simulator pc download - Download - Simulation
- Times attack - Download - Children
- How to calculate 90 days from date in excel - Guide
- How to calculate position in excel ✓ - Excel Forum
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
552
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
