Forum Discussion

Jason S.'s avatar
Jason S.
Copper Contributor
Jun 13, 2018
Solved

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 le...
Formulas & Functions
Need Help
  • SergeiBaklan's avatar
    SergeiBaklan
    Jun 13, 2018

    Hi Jason,

     

    Please use absolute references in SUMIF like

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

    Autosort - not sure right now

     

     

SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Jun 13, 2018

Hi Jason,

 

Please use absolute references in SUMIF like

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

Autosort - not sure right now

 

 

Jason S.'s avatar
Jason S.
Copper Contributor
Jun 13, 2018

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

Resources