Summing various rows of criteria match

		Microsoft Office Forums > Microsoft Excel > Excel
Summing various rows of criteria match

FAQ

Thread Tools

Display Modes

04-14-2022, 06:39 AM

fluis

Mac OS X

Office 2016 for Mac

Banned

Join Date: Apr 2022

Posts: 1

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?

« Previous Thread | Next Thread »

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

Other Forums: Access Forums

All times are GMT -7. The time now is 09:03 AM.