how do you add up a series of numbers in one column using a critera of
another column?

Column A Column B
Apples 1,112
Pears 1,548
Apples 2,544

What is the total number of apples...??? What is the right formula

if(a1:a3=Apples then add B 1:b3)

Try the SUMIF function:

=SUMIF(A1:A3,"Apples",B1:B3)

HTH,
Elkar


"Ben" wrote:

how do you add up a series of numbers in one column using a critera of
another column?

Column A Column B
Apples 1,112
Pears 1,548
Apples 2,544

What is the total number of apples...??? What is the right formula

if(a1:a3=Apples then add B 1:b3)

Hello, I have a similar issue. In my situation, I'm trying to say," If A1:A5
= CA or DE or NJ or NY or PA or WI, then sum B1:B5"

Can anyone help?

Column A Column B
CA 2
NJ 3
DE 4
SC 5
TN 6

"Elkar" wrote:

Try the SUMIF function:

=SUMIF(A1:A3,"Apples",B1:B3)

HTH,
Elkar


"Ben" wrote:

how do you add up a series of numbers in one column using a critera of
another column?

Column A Column B
Apples 1,112
Pears 1,548
Apples 2,544

What is the total number of apples...??? What is the right formula

if(a1:a3=Apples then add B 1:b3)

List the criteria in a range of cells.

D1:D6 = CA, DE, NJ, NY, PA, WI

Then:

=SUMPRODUCT(--(ISNUMBER(MATCH(A1:A5,D1:D6,0))),B1:B5)

--
Biff
Microsoft Excel MVP


"SwtHapa8" wrote in message
...
Hello, I have a similar issue. In my situation, I'm trying to say," If
A1:A5
= CA or DE or NJ or NY or PA or WI, then sum B1:B5"

Can anyone help?

Column A Column B
CA 2
NJ 3
DE 4
SC 5
TN 6

"Elkar" wrote:

Try the SUMIF function:

=SUMIF(A1:A3,"Apples",B1:B3)

HTH,
Elkar


"Ben" wrote:

how do you add up a series of numbers in one column using a critera of
another column?

Column A Column B
Apples 1,112
Pears 1,548
Apples 2,544

What is the total number of apples...??? What is the right formula

if(a1:a3=Apples then add B 1:b3)

Hi,

While, sumif is definitely a better formula to use, you can also use an
array formula (Ctrl+Shift+Enter) here (i would not advise you to use an array
formula though). This is purely for your understanding

=sum(if((rangeA="Apples",RangeB))

Regards

Ashish Mathur

"Ben" wrote:

how do you add up a series of numbers in one column using a critera of
another column?

Column A Column B
Apples 1,112
Pears 1,548
Apples 2,544

What is the total number of apples...??? What is the right formula

if(a1:a3=Apples then add B 1:b3)

In my opinion instead of deriving solutions using formulas in such type
of situation, inbuilt tool like pivot table can be used, this will
-inter alia- sum all the Apples in your database and lend you
flexibility to alter your reports any time.

REGARDS
RAZA


--
RAZA
------------------------------------------------------------------------
RAZA's Profile: http://www.excelforum.com/member.php...o&userid=34186
View this thread: http://www.excelforum.com/showthread...hreadid=540494