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?
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?
