Isolating payments

Occasional Visitor

In my spreadsheet I have 286 owners that have made specific payments. I need to isolate those 286 payments and provide only that total. How do I isolate these payments and separate them to only reflect this total. The payment is categorized under QM.  

1 Reply


Let's say the category is in C2:C1000 and the payment in P2:P1000


=SUMIF(C2:C1000, "QM", P2:P1000)


Or do I misunderstand your question?