Clowe
New member
- Joined
- Jun 5, 2018
- Messages
- 4
- Reaction score
- 0
- Points
- 0
- Excel Version(s)
- Excel 2016
Hi,
I'm trying to write a formula with multiple criteria.
Scenario:
spreadsheet with multiple columns
A: Doc Type (approx.4 different types)
B: Doc # (multiple numbers, some may repeat as the document may include multiple lines
C: $amount
will like to count the number of transactions where the amount is more than $50K. But if the Doc # appears more than once, it needs to count it as one transaction and sum the total to compare to the $50K.
Am I being too ambitious?
Please help.
Chris
I'm trying to write a formula with multiple criteria.
Scenario:
spreadsheet with multiple columns
A: Doc Type (approx.4 different types)
B: Doc # (multiple numbers, some may repeat as the document may include multiple lines
C: $amount
will like to count the number of transactions where the amount is more than $50K. But if the Doc # appears more than once, it needs to count it as one transaction and sum the total to compare to the $50K.
Am I being too ambitious?
Please help.
Chris