sum cells based on another cell value

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,
I have column A listing whole numbers. Column B lists categories a,b, or c.
I would like to sum the values in column A only if the corresponding cell in
Column B contains the letter c.

ie.
10 c
20 b
15 c

sum = 25
 
Hello there,

Try a SumIf function:

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

Hope this helps

Judith
 
=SUMIF(B:B,"c",A:A)

--

HTH

RP
(remove nothere from the email address if mailing direct)
 

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

Sum Values from different column 1
SUM Char 9
SUM - IF - AND 7
SUM question 4
Sum a range based on another range of cells 8
Need sum of top values in a range based on criteria 5
SUM formula results returns 0 value 7
How to add values in one column based on values in another column 6

Back
Top