1. Due to the recent site upgrade, the iPadForums (iPF) App will no longer work. The new iPadForums.net website has been designed from the ground up to work perfectly from any mobile, tablet, or desktop computer using the built in internet browser. Create a shortcut to iPadForums.net on your home screen by following these steps: Create an icon for iPadForums.net

Fantasy football auction spreadsheet in Numbers

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

  1. Dave0219
    Offline

    Dave0219 iPF Noob

    Joined:
    Aug 19, 2012
    Messages:
    1
    Thanks Received:
    0
    Trophy Points:
    0
    Ratings:
    +0 / 0
    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
aution football draft template
,
excel fantasy football auction spreadsheet
,
excel format fantasy football auction spreadsheet
,

excel spreadsheet for calculating fantasy football auction values

,
fantasy football auction max bid formulas in excel
,
fantasy football max bid spreadsheet
,
football score numbers spreadsheet
,
formula for fantasy football auction values
,

free fantasy football auction excel spreadsheet 2014

,
ipad numbers fantasy football