Notifications
Clear all
Advanced Excel Formulas
2
Posts
2
Users
0
Reactions
90
Views
Topic starter
Hi
Similar to my above topic, the third practice in the AVERAGEIF practice sheet asks for Units sold before May 2019. I took this as the sum of Units sold before 01 May 2019, however the answer provided is the sum of sales before the 01May 2019. My answer is 33900 as apposed to the sum of sales before 01 May 2019 which would be $1,864,500. Formatting would also be incorrect as the cell is set to currency.
Posted : 28/04/2019 10:07 pm
Hi Gavin,
Thanks for spotting those errors. I've fixed them and uploaded the revised workbook. It's probably quicker and easier for you just to make the corrections in the file you're working instead of downloading all of the workbooks again.
Mynda
Posted : 28/04/2019 11:18 pm
