Resolved: Excel practice exam 3 - not clear solution

Hey,

I'm going through intro to excel course and i've found practice exam 3 somewhat confusing. In question 5 the hint is NOT to take into consideration rows marked as "total" and the explanation is to use specific function (want to avoid spoilers so i'm not pasting here the function, but you can check it in Q5 solution) and then take the sum of first ten rows but if we do so then we get -17.5 mln while the correct answer is -8.8 mln. Because this function sums everything, each line AND totals, we need to divide everything by 2 to get the correct result. Alternatively, we can do a sumifs function for totals only, or for each partner company not being total but that would be painful. Just wanted to share my POV, in case someone else struggles with understanding what's happening here :)

Cheers!

EDIT:// just googled that it is also possible to do sumifs but instead of for "Total" we can use "<>Total" which means for everything except total.