View Single Post
  #1   Report Post  
Anauna
 
Posts: n/a
Default sum cells based on another cell value

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
--
Thank-you and all suggestions are appreciated.