I am attempting to track sales occurrences per day, week, month, year.
The day is working using the following:
=COUNTIFS(E8:E100014, TODAY())
Also working is the current week:
=(SUMPRODUCT((E8:E10014+0>=TODAY()-WEEKDAY(TODAY())+1)*(E8:E10014+0<=TODAY()-WEEKDAY(TODAY())+7)))
I am failing terribly when attempting to simply count the number of occurences within column E.
I feel as my job has turned into spreadsheets. Possibly worth pointing out is the worksheet I use is a destination of multiple source worksheets.
Bookmarks