Trying to sort a spreadsheet with SUMIF formulas

[Jason S.]

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.

[#2 · Accepted solution]

Hi Jason,

Please use absolute references in SUMIF like

=SUMIF($C$2:$C$7, "Bill", $B$2:$B$7)

Autosort - not sure right now

[#3]

Awesome. Thanks, that worked. Autosort isn't too big of a deal. I'm just happy that the sort feature works now