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 download pc - Download - Simulation
- Internet cafe simulator download - Download - Simulation
- Times attack - Download - Children
- We limit the number of times you can request security codes in a given amount of time. we have this limit to protect your security. for help accessing your account, learn more, or try again later. - Facebook Forum
- The system time is invalid. this may be a result of a loss in battery power ✓ - CPU & Desktop Forum
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
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
