How to sum few items

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.

Use the SUMIF function

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

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

--

HTH

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


"Little Master" <Little.Master.1xgd2b_1130234707.2198@excelforum-nospam.com>
wrote in message
news:Little.Master.1xgd2b_1130234707.2198@excelforum-nospam.com...
>
> 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.
>
>
> --
> Little Master
> ------------------------------------------------------------------------
> Little Master's Profile:
http://www.excelforum.com/member.php...o&userid=28227
> View this thread: http://www.excelforum.com/showthread...hreadid=479050
>

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