HOW TO USE OF SUMIF FUNCTION TO SUM TOTAL NO OF PQ1, PQ2, OTQ OF .
 

HOW TO USE OF SUMIF FUNCTION TO SUM TOTAL NO OF PQ1, PQ2, OTQ OF .
 

=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
...

HOW TO USE OF SUMIF FUNCTION TO SUM TOTAL NO OF PQ1, PQ2, OTQ OF .
 

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
...