Fantasy football auction spreadsheet in Numbers

Discussion in 'iWork Forum' started by Dave0219, Aug 19, 2012.

  1. Dave0219

    Expand Collapse
    iPF Noob

    Aug 19, 2012
    Thanks Received:
    I had an excel spreadhseet that I have been using for years for my fantasy football auction. I tried the same formula in Numbers and it doesn't work.

    Basically what I'm trying to do is figure out each teams high bid.

    Each team starts with $160 and has to fill 16 positions. Each spot has to be filled with a minimum of $1. So each team starts out with a high bid of $145.

    The formula I was using in excel was =160-SUM(C3:C18)-COUNTBLANK(B3:B18)+1

    C3:C18 was the players names and B3:B18 was the dollar amount they were auctioned off for.

    When I do the same thing in excel I get an error message that says "The range B3:B18 can't be used as a single value."

    Can anyone help me?

Share This Page

Search tags for this page

cbs fantasy spreadsheet for ipad


excel spreadsheet for calculating fantasy football auction values


fantasy football auction excel spreadsheet

fantasy football auction max bid excel formula
fantasy football auction maxbid formula
fantasy football excel max bid formula
fantasy football forums auction format
fantasy football max bid formula
fantasy max bid excel

free fantasy football auction excel spreadsheet 2014