rdrjr
New Member
- Joined
- Sep 28, 2019
- Messages
- 32
- Office Version
- 365
- Platform
- Windows
I have a table that I enter the date such as 01-01-21 and the amount in a total column. I need to average the total amount for each day of the week. I have tried using the following formula but it returns the #Value error.
=AVERAGE(IF(Earnings[DATE]=2,Earnings[TOTAL],"")) 'my thinking is this would average all totals for the Mondays.
=AVERAGE(IF(Earnings[DATE]=2,Earnings[TOTAL],"")) 'my thinking is this would average all totals for the Mondays.