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

    Dave0219 iPF Noob

    Aug 19, 2012
    Thanks Received:
    Trophy Points:
    +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