| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 ??? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 ??? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 ??? |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Insert Column after specific text title the new column and add for | Excel Discussion (Misc queries) | |||
| Sum specific column rows based on 2 different column criteria | Excel Worksheet Functions | |||
| find a specific value in a column and write another column | Excel Discussion (Misc queries) | |||
| How do I update Column #1 based on specific value of column #2? | Excel Worksheet Functions | |||
| SUM/COUNT column(s) based on specific value present within the column | Excel Worksheet Functions | |||
Hybrid Mode
