| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Other Sum Question
I am trying to come up with total to complete by Plant Division. All the data is on across 1 Row. Ex. Job /Paint/Division /Detail /Division /Inspection /Division /Delivery /Division Roger - 1500.00 - C - 180.00 - C - Inspection - 125.00 - AS - 225.00 - C I want total for Division C and Division AS. I have a column for each Division's Total at the end of that Row. -- BradP ------------------------------------------------------------------------ BradP's Profile: http://www.excelforum.com/member.php...fo&userid=6255 View this thread: http://www.excelforum.com/showthread...hreadid=518981 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Other Sum Question
Assumptions:
A1:I1 contains your labels A2:I2 contains your data Formula: =SUMIF(C2:I2,"C",B2:H2) Hope this helps! In article , BradP wrote: I am trying to come up with total to complete by Plant Division. All the data is on across 1 Row. Ex. Job /Paint/Division /Detail /Division /Inspection /Division /Delivery /Division Roger - 1500.00 - C - 180.00 - C - Inspection - 125.00 - AS - 225.00 - C I want total for Division C and Division AS. I have a column for each Division's Total at the end of that Row. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Other Sum Question
I adjusted the explain on my speadsheet. Any help were to great -- BradP ------------------------------------------------------------------------ BradP's Profile: http://www.excelforum.com/member.php...fo&userid=6255 View this thread: http://www.excelforum.com/showthread...hreadid=518981 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Other Sum Question
Having taken a look at your sample data, it looks like A2:J2 contains
your data. If this is correct, try... =SUMIF(C2:J2,"C",B2:I2) ....which will return 1905. The cells being summed are B2 (1500), D2 (180), and I2 (225). Hope this helps! In article , BradP wrote: I adjusted the explain on my speadsheet. Any help were to great |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Is this the proper place to ask my question? | Excel Discussion (Misc queries) | |||
| Summary Page Question | Excel Discussion (Misc queries) | |||
| Pivot table question | Excel Discussion (Misc queries) | |||
| How do I find and replace a question mark in Excel? | Excel Discussion (Misc queries) | |||
| An easy macro question and one I believe to be a little more diffi | Excel Worksheet Functions | |||
Linear Mode
