Notifications
Clear all
Excel Expert
2
Posts
2
Users
0
Reactions
98
Views
Topic starter
Hi, please pardon my mild case of OCD. The formula in cell C111 of the downloadable file for the course on lesson 3.61 returns the sales values of 51, 12, 10 and 50 respectively for the regions. The "sumif" formula I was expecting is:
=SUMIF(Table_1.1[Region],B111#,Table_1.1[Sales]) which returns the summed values of 90, 83, 79 and 109. I hope this thinking is correct 🙂
Posted : 18/12/2023 12:21 pm
Absolutely correct, Peter. Good catch! I'll fix that up. Thanks for letting me know.
Mynda
Posted : 18/12/2023 10:22 pm
