=sumif(A:A,"PQ1",B:B)

etc.

Adjust to suit.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Baljeet" wrote in message
...

Isn't it fun, guessing at what the OP is looking for, especially when (s)he
doesn't even bother to post the entire question in the body of the post?

My interpretation is:

=Sum(Sumif(A:A,{"PQ1","PQ2","OTQ"},B:B))

--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Bob Phillips" wrote in message
...
=sumif(A:A,"PQ1",B:B)

etc.

Adjust to suit.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my
addy)

"Baljeet" wrote in message
...