Sum cells based on value of other cells
 

I've tried finding the answer for this by searching, but didn't have
luck.

I have a table where column "A" contains a single character or empty.
Column "B" has a dollar value. I need to sum all "B" cells where "A"
has a specific letter, but can't figure out the right way to do this.

Thanks in advance,
Chris

Sum cells based on value of other cells
 

Try something like this:

=SUMIF(A1:A10,"A",B1:B10)

Does that help?
--------------------------

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)

"Chris" wrote in message
...
I've tried finding the answer for this by searching, but didn't have
luck.

I have a table where column "A" contains a single character or empty.
Column "B" has a dollar value. I need to sum all "B" cells where "A"
has a specific letter, but can't figure out the right way to do this.

Thanks in advance,
Chris

Sum cells based on value of other cells
 

Try this:

=SUMIF(A1:A100,"A",B1:B100)

Wiill sum column B where column A = "A".

Or, use a cell to hold the criteria:

D1 = A

=SUMIF(A1:A100,D1,B1:B100)


--
Biff
Microsoft Excel MVP


"Chris" wrote in message
...
I've tried finding the answer for this by searching, but didn't have
luck.

I have a table where column "A" contains a single character or empty.
Column "B" has a dollar value. I need to sum all "B" cells where "A"
has a specific letter, but can't figure out the right way to do this.

Thanks in advance,
Chris

Sum cells based on value of other cells
 

Worked perfectly, thanks!

On Mar 2, 1:31 pm, "T. Valko" wrote:
Try this:

=SUMIF(A1:A100,"A",B1:B100)

Wiill sum column B where column A = "A".

Or, use a cell to hold the criteria:

D1 = A

=SUMIF(A1:A100,D1,B1:B100)

--
Biff


Microsoft Excel MVP

"Chris" wrote in message

...

I've tried finding the answer for this by searching, but didn't have
luck.

I have a table where column "A" contains a single character or empty.
Column "B" has a dollar value. I need to sum all "B" cells where "A"
has a specific letter, but can't figure out the right way to do this.

Thanks in advance,
Chris

Sum cells based on value of other cells
 

You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"Chris" wrote in message
...
Worked perfectly, thanks!

On Mar 2, 1:31 pm, "T. Valko" wrote:
Try this:

=SUMIF(A1:A100,"A",B1:B100)

Wiill sum column B where column A = "A".

Or, use a cell to hold the criteria:

D1 = A

=SUMIF(A1:A100,D1,B1:B100)

--
Biff


Microsoft Excel MVP

"Chris" wrote in message

...

I've tried finding the answer for this by searching, but didn't have
luck.

I have a table where column "A" contains a single character or empty.
Column "B" has a dollar value. I need to sum all "B" cells where "A"
has a specific letter, but can't figure out the right way to do this.

Thanks in advance,
Chris