|
|
#1
04-14-2022, 06:39 AM
|
|||
|
|||
Summing various rows of criteria match
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? 
|
| Thread Tools | |
| Display Modes | |
|
|
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 |
Mac OS X 
Office 2016 for Mac
Threaded Mode