I have a very specific thing I want the Google Sheets to give me, but I'm unsure which approach would be best.
|Client ID||Amount||Status||Is delivered|
In the following fictitious table (for context in the 3rd column
Status I have showing
Sent if the Invoice was sent to the client and
Delivered if it was actually paid by the client), so in the 4th
Is Delivered column I want to get a
yes response if a client from the first column has paid - as in
Delivered an amount equal or greater than 100 USD. This could be done with a nested IF function I think, but the problem is, in the first column I also have duplicate values and I want to get the sum of at least 100 USD if a unique client has delivered either all together or fractionally that amount, so I'm not sure what kind of function I could use to turn all of that into a
yes response. Also, I want it to count the sums a client paid only if the 3rd column
For example: client 56691668 has Delivered a total of 120 USD, so now I want in the 4th column only to show Yes.