Forum Discussion
Trying to sort a spreadsheet with SUMIF formulas
I have created a basic "movie draft" spreadsheet, where people pick movies and their box office totals are totaled up and the person with the highest overall total wins.
When I try to sort the leader board by rank (see attached spreadsheet) the SUMIF Formula seems to break. How can I sort the leader board by rank while not breaking the SUMIF statements? Also can I have the leader board auto sort so that when the box office totals are edited the leader board will automatically sort?
I'm using excel 2013 if that makes any difference.
Thanks.
Hi Jason,
Please use absolute references in SUMIF like
=SUMIF($C$2:$C$7, "Bill", $B$2:$B$7)
Autosort - not sure right now
Hi Jason,
Please use absolute references in SUMIF like
=SUMIF($C$2:$C$7, "Bill", $B$2:$B$7)
Autosort - not sure right now
Awesome. Thanks, that worked. Autosort isn't too big of a deal. I'm just happy that the sort feature works now
