Monthy financials expressedas average per day

Closed
milty - Mar 15, 2010 at 02:57 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Mar 15, 2010 at 03:01 PM
Hello,

I have a workbook with a worksheet for each day of the month.

A summary sheet shows totals per date (1st, 2nd, 3rd, &tc.).

I want to create a statistical sheet that shows AVERAGES per day of week, for trend analysis.

I have a formula that works to show the totals for each day of the week

=SUMPRODUCT(--(WEEKDAY('FD5'!B10:B40)=1)|'FD5'!S10:S40)

but I want to break that down to an average per day of week.

Please HELP!!!
Related:

1 response

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Mar 15, 2010 at 03:01 PM
could you post your worksheet at some share site like https://authentification.site
0