Forum Discussion
John74Racing
Apr 21, 2020Copper Contributor
Counting number of times the same entry has been entered in the previous 7 days.
Looking for a function that can count the number of times the same value entry has been entered in the previous 7 days. Or even better would be from Sunday at 6:00am to Sunday 5:59am. We have a trans...
gyankosh
Apr 21, 2020Brass Contributor
If you just want to count , how many times the player fee has been added, a simple COUNTIF can be used.
=countif(cell C3, "="PLAYER FEE")
tHE OUTPUT WILL BE 1 OR 0. iT CAN BE COUNTED.
IF YOU WANT CUMULATIVE SUM, MAKE ONE MORE COLUMN AND ADD THE UPPER CELL WITH THE CELL TO THE LEFT.
I hope it helps.