| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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=548072 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
using an IF function for a total
Drummy,
I note that the 7 columns listed does not match the ragne G2:J16 given at the end. However, the formula below is for the range given and I assume that ,column 4, the income, is the calculated price x the returened cartoons. COLUMN1 COLUMN2 FORMULA LABEL Senior =SUMIF(G3:G16,"Senior",J3:J16) Junior =SUMIF(G3:G16,"Junior",J3:J16) Sjunior =SUMIF(G3:G16,"SJunior",J3:J16) Good luck Drummy wrote: 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=548072 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
using an IF function for a total
We will need to Sum two SumIfs for each division because SumIf will not sum
on two different ranges: =SUM(SUMIF(D2:D16,"Senior",G2:G16),SUMIF(D2:D16,"S enior",J2:J16)) Mike F "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=548072 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Drop Down Total Function | Excel Discussion (Misc queries) | |||
| HOW TO USE OF SUMIF FUNCTION TO SUM TOTAL NO OF PQ1, PQ2, OTQ OF . | Excel Worksheet Functions | |||
| using an IF function for a total | Excel Discussion (Misc queries) | |||
| Using an IF function for a total | Excel Worksheet Functions | |||
| Using the sum function with a blank total | Excel Programming | |||
![Drummy[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
