Hello there,
Try a SumIf function:
=SUMIF(B1:B3,"c",A1:A3)
Hope this helps
Judith
-----Original Message-----
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.
.
|