Formulas

[Sara Sadler]

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?

 

[akphidelt]

Yea if you use Sumif.

So you can say

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

 

[Don Guillett]

Look in the help index for SUMIF