Using an IF function for a total

[Drummy]

ok, say I have a fundraising worksheet for a tennis club

* I have 7 columns with in order;

division, cartons, returned cartons, income, cartons, returned cartons, income

3 divisions (junior, senior and sjunior) are selling 2 types of chocolates,

* each row represents a player from the club

Senior 15 15 $30.00 15 15 $75.00
Senior 15 15 $30.00 15 15 $75.00
Senior 15 15 $30.00 15 15 $75.00
Senior 15 14 $28.00 15 12 $60.00
Senior 15 13 $26.00 15 13 $65.00
Senior 15 15 $30.00 15 14 $70.00
Senior 15 13 $26.00 15 15 $75.00
Senior 15 15 $30.00 15 15 $75.00
Junior 10 9 $18.00 10 9 $45.00
Junior 10 10 $20.00 10 10 $50.00
Senior 15 9 $18.00 15 14 $70.00
SJunior 5 5 $10.00 5 5 $25.00
SJunior 5 3 $6.00 5 5 $25.00
Junior 10 10 $20.00 10 13 $65.00
Senior 15 15 $30.00 15 14 $70.00

(income is the returned cartons * carton price @ $2 and $5)

what would the formula be for the total of each division
if the worksheet above is G2:J16

???

[Ardus Petus]

Please don't multipost

--
AP

"Drummy" <[email protected]> a écrit dans
le message de news: [email protected]...
>
> ok, say I have a fundraising worksheet for a tennis club
>
> * I have 7 columns with in order;
>
> division, cartons, returned cartons, income, cartons, returned cartons,
> income
>
> 3 divisions (junior, senior and sjunior) are selling 2 types of
> chocolates,
>
> * each row represents a player from the club
>
> Senior 15 15 $30.00 15 15 $75.00
> Senior 15 15 $30.00 15 15 $75.00
> Senior 15 15 $30.00 15 15 $75.00
> Senior 15 14 $28.00 15 12 $60.00
> Senior 15 13 $26.00 15 13 $65.00
> Senior 15 15 $30.00 15 14 $70.00
> Senior 15 13 $26.00 15 15 $75.00
> Senior 15 15 $30.00 15 15 $75.00
> Junior 10 9 $18.00 10 9 $45.00
> Junior 10 10 $20.00 10 10 $50.00
> Senior 15 9 $18.00 15 14 $70.00
> SJunior 5 5 $10.00 5 5 $25.00
> SJunior 5 3 $6.00 5 5 $25.00
> Junior 10 10 $20.00 10 13 $65.00
> Senior 15 15 $30.00 15 14 $70.00
>
> (income is the returned cartons * carton price @ $2 and $5)
>
> what would the formula be for the total of each division
> if the worksheet above is G2:J16
>
> ???
>
>
> --
> Drummy
> ------------------------------------------------------------------------
> Drummy's Profile:
> http://www.excelforum.com/member.php...o&userid=34780
> View this thread: http://www.excelforum.com/showthread...hreadid=548071
>

[Bob Phillips]

=SUMPRODUCT(--(G2:G16="Senior"),(H2:H16+I2:I16))

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Drummy" <[email protected]> wrote in
message news:[email protected]...
>
> ok, say I have a fundraising worksheet for a tennis club
>
> * I have 7 columns with in order;
>
> division, cartons, returned cartons, income, cartons, returned cartons,
> income
>
> 3 divisions (junior, senior and sjunior) are selling 2 types of
> chocolates,
>
> * each row represents a player from the club
>
> Senior 15 15 $30.00 15 15 $75.00
> Senior 15 15 $30.00 15 15 $75.00
> Senior 15 15 $30.00 15 15 $75.00
> Senior 15 14 $28.00 15 12 $60.00
> Senior 15 13 $26.00 15 13 $65.00
> Senior 15 15 $30.00 15 14 $70.00
> Senior 15 13 $26.00 15 15 $75.00
> Senior 15 15 $30.00 15 15 $75.00
> Junior 10 9 $18.00 10 9 $45.00
> Junior 10 10 $20.00 10 10 $50.00
> Senior 15 9 $18.00 15 14 $70.00
> SJunior 5 5 $10.00 5 5 $25.00
> SJunior 5 3 $6.00 5 5 $25.00
> Junior 10 10 $20.00 10 13 $65.00
> Senior 15 15 $30.00 15 14 $70.00
>
> (income is the returned cartons * carton price @ $2 and $5)
>
> what would the formula be for the total of each division
> if the worksheet above is G2:J16
>
> ???
>
>
> --
> Drummy
> ------------------------------------------------------------------------
> Drummy's Profile:
http://www.excelforum.com/member.php...o&userid=34780
> View this thread: http://www.excelforum.com/showthread...hreadid=548071
>