At 19:43 14/07/2008 -0500, Wade Smart wrote:
One of the columns is calculated by referencing another column and
IF the column is checked ( has a x in it) then perform this calculation:
$Cost / $Number_of_players + $service = $price_per_player
Column B2 is $Cost
$number_of_players is column B3 though B30 only
$service is column G3 through G30 only
And
$price_per_player is column H3 though H30
So basically, if there are say 15 people on the roster and only 4 have paid
the calculation would be:
(test values)
$500 / 4 + $5 = $130
And in the rows that are checked (the committed column) those rows
would have $130 showing that if only 4 players played, it would cost $130 each.
It's not entirely clear to me why you have lists of twenty-eight
values. Alternatively, if these are the potential players, it is not
clear why you want the same value (apparently) listed twenty-eight times.
But anyway, what you probably need is the COUNTIF() function. This
counts how many members of a range satisfy a criterion. Where you
have the "4" for the number of players, you may need something like
COUNTIF(B$3:B$30;"x"). This counts how many cells in the relevant
column contain "x". Alternatively, you may prefer to replace "x"
(meaning "equals x") by "<>" (meaning "is not null"), but note that
this form would count any cell containing an explicit but invisible
blank. You can do smarter things with COUNTIF() by giving it a
regular expression as the criterion.
I trust this helps.
Brian Barker
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
