Forum Discussion
Excel: Perform the calculations, in order to get the total amount spent for the year
I have been given 3 tasks and I complete the first one with VLOOKUP but have no idea how to do the other 2 tasks and I have less than 3 hours to complete, can anyone help me, please? Thanks a lot in ...
Task 2:
=SUM(C4:C15*(1-D4:D15))
Task 3a:
=SUMIF(Table3[Location],"Havana",Table3[Order for])3b (An Insider function is being used):
=LET(f,FILTER(Table3,Table3[Location]="Havana"),TAKE(SORT(f,3,-1),1,1))