Welcome to iPadForums.net Guest - Click Here to Register

Fantasy football auction spreadsheet in Numbers

This is a discussion on Fantasy football auction spreadsheet in Numbers within the iWork Forum forums, part of the iPad App Store category; 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 ...

iPadForums.net is the original Apple iPad Forum! Registered Users do not see these ads. Please Register - It's Free!
+ Reply to Thread
Results 1 to 1 of 1
  1. #1
    iPF Noob
    Member #
    237851
    Join Date
    Aug 2012
    Posts
    1

    Fantasy football auction spreadsheet in Numbers

    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?

  2. Ads



Home | Forum | Active Topics | What's New

Links

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Similar Threads

  1. Numbers spreadsheet app
    By mdholm in forum iPad General Discussions
    Replies: 3
    Last Post: 06-09-2012, 10:13 AM
  2. numbers continually updating 1 spreadsheet
    By dirtdigger in forum iWork Forum
    Replies: 2
    Last Post: 02-23-2012, 06:13 PM
  3. Fantasy Football Score Tracking App
    By Boobar in forum iPad Apps
    Replies: 0
    Last Post: 10-01-2011, 12:49 AM
  4. Excel spreadsheet row numbers
    By candirisk in forum iPad Help
    Replies: 1
    Last Post: 06-22-2011, 12:27 AM
  5. Replies: 2
    Last Post: 06-16-2011, 12:36 AM

Search tags for this page

fantasy football auction spreadsheet

,
fantasy football excel spreadsheet
,

fantasy football excel spreadsheet 2012

,

fantasy football spreadsheet

,

fantasy football spreadsheet 2012

,
fantasy football spreadsheet 2012 free
,
fantasy spreadsheet
,

football spreadsheet

Click on a term to search for related topics.