Formulas
 

I am trying to find a way to create a formula that calculates the following:

If the value of a cell in column A equals a certain criteria, what is the
total value of the cells in column B that meet the crtieria in column A.

For example:
A B
40 120.00
40 30.00
50 40.00
60 50.00

Where you see 40 in the column A, I want to know the total value of column
B, where 40 appers in the corresponding cell in column A.

Can this be achieved with a formula?
--
Kind regards

Sara

Formulas
 

Yea if you use Sumif.

So you can say

=Sumif($A$1:$A$4,40,$B$1:$B$4)

"Sara Sadler" wrote:

I am trying to find a way to create a formula that calculates the following:

If the value of a cell in column A equals a certain criteria, what is the
total value of the cells in column B that meet the crtieria in column A.

For example:
A B
40 120.00
40 30.00
50 40.00
60 50.00

Where you see 40 in the column A, I want to know the total value of column
B, where 40 appers in the corresponding cell in column A.

Can this be achieved with a formula?
--
Kind regards

Sara

Formulas
 

Look in the help index for SUMIF

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Sara Sadler" wrote in message
...
I am trying to find a way to create a formula that calculates the
following:

If the value of a cell in column A equals a certain criteria, what is the
total value of the cells in column B that meet the crtieria in column A.

For example:
A B
40 120.00
40 30.00
50 40.00
60 50.00

Where you see 40 in the column A, I want to know the total value of column
B, where 40 appers in the corresponding cell in column A.

Can this be achieved with a formula?
--
Kind regards

Sara