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?

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?

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?

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?

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?

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.