LinkBack URL
About LinkBacks
Or
Formula:
=SUMPRODUCT((A1:A100>=DATE(YEAR(TODAY()),MONTH(TODAY())-6,DAY(TODAY())))*(WEEKDAY(A1:A100)=2),B1:B100)/SUMPRODUCT((A1:A100>=DATE(YEAR(TODAY()),MONTH(TODAY())-6,DAY(TODAY())))*(WEEKDAY(A1:A100)=2))
Or
Formula:=SUMPRODUCT((A1:A100>=DATE(YEAR(TODAY()),MONTH(TODAY())-6,DAY(TODAY())))*(WEEKDAY(A1:A100)=2),B1:B100)/SUMPRODUCT((A1:A100>=DATE(YEAR(TODAY()),MONTH(TODAY())-6,DAY(TODAY())))*(WEEKDAY(A1:A100)=2))
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
@Sixthsense - This doesn't appear to work for me, producing DIV error.
Attached the sheet im working on
AvgPerDay.xlsx
The formula should be
Formula:=SUMPRODUCT((A2:A986>=DATE(YEAR(TODAY()),MONTH(TODAY())-6,DAY(TODAY())))*(WEEKDAY(A2:A986)=2),B2:B986)/SUMPRODUCT((A2:A986>=DATE(YEAR(TODAY()),MONTH(TODAY())-6,DAY(TODAY())))*(WEEKDAY(A2:A986)=2))
1st row contains Column Headers which is TEXT characters and in A987 cell there is a text value called Grand Total
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks