Summing various rows of criteria match

Purfleet · #2 04-16-2022, 12:57 PM

Quote:

Originally Posted by fluis

I am trying to calculate collections (payment/charges) but the payments and charges are not on the same row. To circumvent that problem, I tried to create a formula essentially stating "if unique id, Item number and date of purchase match, divide the sum of payments by the sum of charges”, but formula didn’t work.

What is the best way to calculate this?

please post an example worksheet, so we can see what the data looks like

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Add criteria to MAX INDEX MATCH	ollyhughes	Excel	2	02-25-2022 03:38 AM
Formula that looks at more than one criteria and then adds up those that match	DazzyBee	Excel	2	01-20-2017 11:29 PM
Create a unique list of values that match a criteria, sorted in order of another criteria	BradRichardson	Excel	2	01-03-2017 12:25 AM
Using a VLOOKUP - when 2 rows match criteria it returns the first value in the cel only how 2 change	djrobst	Excel	4	10-28-2015 01:32 AM
Count unique values that match 2 or more criteria	caeiro01	Excel	1	10-25-2015 02:34 AM