I have been given what seems like a pretty simple project -- to determine our best clients over time as measured by them paying over a certain threshold amount by recorded invoice. I was handed a file with dates of invoices paid by select clients (also listed) with their amounts paid all the way back to 1950. I have added a column to determine if they have met the threshold criteria and recorded a 1 for Yes or " " for No (column D). I am attaching a small slice of the much larger xls file (original file has over 20k entries with all the clients. I have been asked to record the dates of such threshold payments being made, tally the count by year across all clients regardless of client clearing the threshold, and tally the total count of threshold payments by client. Can someone assist with the questions in G3, J3, and P2? Thank you in advance!
