How to sum few items

[Little Master]

Hi

A B

X 1
Y 1
X 2
Y 2
Y 4
X 5


I want to sum up those numbers in B column which contains Y in their
opposite in A column.

 

[Simon C]

Use the SUMIF function

eg
=SUMIF(A1:A6,"=Y",B1:B6)

 

[Bob Phillips]

=SUMIF(A1:A10,"Y",B1:B10)

--

HTH

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


"Little Master" <[email protected]>
wrote in message
news:[email protected]...

 

[Little Master]

Thanks to both of you (Simon & Bob), Thanks alot