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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

SUMIF COMMAND WITH CONDITIONAL CRITERIA (I.E. BETWEEN CERTAIN DATE 1
Use TODAY() function as the criteria in a SUMIF formula 1
How to count the number of letters in a cell? 7
Mulitiple functions in one cell 1
VLOOKUP Newbie Question 5
Sumif apllying to all sheets in workbook 2
How do I calculate the date an employee will reach a specific age? 0
SUMIF function 3

Top