| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Only adding up specific categories
I was wondering if there is a simple way to do this.
1. Column A & B are both categories so for example Office Cleaning could be in either columns 2. Column C are the associated dollar values 3. Only add up cells in Column C is "Office Cleaning" is either in Column A or B Is this possible? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Only adding up specific categories
SUMIF
-- Brevity is the soul of wit. " wrote: I was wondering if there is a simple way to do this. 1. Column A & B are both categories so for example Office Cleaning could be in either columns 2. Column C are the associated dollar values 3. Only add up cells in Column C is "Office Cleaning" is either in Column A or B Is this possible? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Only adding up specific categories
I am able to get SUMIF to work if all my data is in a column with no
blank. Can't get it to work with blanks in some rows. Any ideas? Dave F wrote: SUMIF -- Brevity is the soul of wit. " wrote: I was wondering if there is a simple way to do this. 1. Column A & B are both categories so for example Office Cleaning could be in either columns 2. Column C are the associated dollar values 3. Only add up cells in Column C is "Office Cleaning" is either in Column A or B Is this possible? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Only adding up specific categories
I would format the data so that only one column contains category information.
-- Brevity is the soul of wit. " wrote: I am able to get SUMIF to work if all my data is in a column with no blank. Can't get it to work with blanks in some rows. Any ideas? Dave F wrote: SUMIF -- Brevity is the soul of wit. " wrote: I was wondering if there is a simple way to do this. 1. Column A & B are both categories so for example Office Cleaning could be in either columns 2. Column C are the associated dollar values 3. Only add up cells in Column C is "Office Cleaning" is either in Column A or B Is this possible? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Only adding up specific categories
See if this works for you. Where "xxx" is Office cleaning. You can use a
cell reference instead of "xxx" also. =SUMIF(A2:A10,"xxx",C2:C10)+SUMIF(B2:B10,"xxx",C2: C10) HTH Regards, Howard wrote in message oups.com... I was wondering if there is a simple way to do this. 1. Column A & B are both categories so for example Office Cleaning could be in either columns 2. Column C are the associated dollar values 3. Only add up cells in Column C is "Office Cleaning" is either in Column A or B Is this possible? |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Only adding up specific categories
L. Howard Kittle wrote:
See if this works for you. Where "xxx" is Office cleaning. You can use a cell reference instead of "xxx" also. =SUMIF(A2:A10,"xxx",C2:C10)+SUMIF(B2:B10,"xxx",C2: C10) Ahhh, breaking eash SUMIF up. ok, that works! Thanks so much. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Referencing a specific number to more general values in a table. | Excel Worksheet Functions | |||
| Link from a specific Cell in Excel to a specific para. in Word | Excel Worksheet Functions | |||
| How do I add specific categories from several worksheets? | Excel Worksheet Functions | |||
| Adding specific Cells Only. | Excel Discussion (Misc queries) | |||
| Adding multiple cells, return specific values | Excel Worksheet Functions | |||
Linear Mode
