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

B

Bob Phillips

=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)
 
R

Ragdyer

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))
 
Top