Forum Discussion
Mariar0531
Apr 05, 2023Copper Contributor
Isolating payments
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 refle...
HansVogelaar
Apr 05, 2023MVP
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?