Sum of value if column contain specific value
 

A B

1 AR 21.40
2 AL 400.00
3 AL 100.00
4 AR 8.90
5 AR 16.90
6 AR 42.00
7 PS 30.00
8 PS 40.00



How to add up column "B" value if the corresponding value in column "A"
equal AR ???

Sum of value if column contain specific value
 

crapit

=SUMIF(A1:A8,"AR",B1:B8)

If you don't know the range you can use

=SUMIF(A:A,"AR",B:B)


Gord Dibben Excel MVP



On Fri, 25 Nov 2005 09:01:09 +0800, "crapit" wrote:

A B

1 AR 21.40
2 AL 400.00
3 AL 100.00
4 AR 8.90
5 AR 16.90
6 AR 42.00
7 PS 30.00
8 PS 40.00



How to add up column "B" value if the corresponding value in column "A"
equal AR ???

Sum of value if column contain specific value
 

Suppose the value at Col "A" contain space E.g "AR "

How come this doesnt work?

=SUMIF(trim(A:A),"AR",B:B)

"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
crapit

=SUMIF(A1:A8,"AR",B1:B8)

If you don't know the range you can use

=SUMIF(A:A,"AR",B:B)


Gord Dibben Excel MVP



On Fri, 25 Nov 2005 09:01:09 +0800, "crapit"
wrote:

A B

1 AR 21.40
2 AL 400.00
3 AL 100.00
4 AR 8.90
5 AR 16.90
6 AR 42.00
7 PS 30.00
8 PS 40.00



How to add up column "B" value if the corresponding value in column "A"
equal AR ???

Sum of value if column contain specific value
 

Modify Gord's formula to:


SUMIF(trim(A:A),"AR*",B:B)


(note the use of the asterisk)


Davi

--
david
-----------------------------------------------------------------------
davidm's Profile: http://www.excelforum.com/member.php...fo&userid=2064
View this thread: http://www.excelforum.com/showthread.php?threadid=48806

Sum of value if column contain specific value
 

Can explain y must I insert the asterisk as the purpose of trim is to remove
space char. ?

"davidm" wrote in
message ...

Modify Gord's formula to:


SUMIF(trim(A:A),"AR*",B:B)


(note the use of the asterisk)


David


--
davidm
------------------------------------------------------------------------
davidm's Profile:
http://www.excelforum.com/member.php...o&userid=20645
View this thread: http://www.excelforum.com/showthread...hreadid=488061