Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Using an IF function for a total
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Using an IF function for a total
=SUMPRODUCT(--(G2:G16="Senior"),(H2:H16+I2:I16))
-- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Drummy" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Custom function | Excel Worksheet Functions | |||
Creating a Custom Excel Function to Calculate Gini Coefficients | Excel Worksheet Functions | |||
sum of total hours not correct | Setting up and Configuration of Excel | |||
clock | Excel Worksheet Functions | |||
How do I total a column which was created using the MID function? | Excel Worksheet Functions |