Formulas with conditions

E

EG

I would like to be able to find the sum of a range of cells if a
corresponding cell in a different column but the same row has a certain
letter.

For example, The cell I want the formula in is L39. The cells in column (I)
have a lable of either C or P as the first letter. The cells in column (K)
have a certain number value. I would like to find the sum in the range of
cells in column K in which the corresponding cell number in Column (I) has
the first letter of C. Thus, if I12=C, I13=C, I14=P, and K12=2, K13=3,
K14=4, then the sum of K12:K14 would be 5.

how can i do this?

eric
 
C

Carim

Hi Eric,

Have a go with sumif() function :

SUMIF(range,criteria,sum_range)

HTH
Carim
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy addition formula of non-consecutive horizontal cells 2
Would like to input 3 letters into a cell, each having a different numerical value 5
Need a proper guru! My head hurts ;( 1
SUMIF with criteria "<>" & "=" 4
number to character and vice-versa 10
SUMPRODUCT formula I think w/ wild card & number vs number as text 8
SUM Char 9
formula for arriving net difference 0

Top