• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User


  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

How to find the first occurrence in of a customer in a table


New Member
I have a sales by customer table. For new customers when the total sales > a certain $ amount, the sales person gets a commission. In a range this formula is easy using Countifs, but how do you do this in a table? Essentially I am counting the sales by customer and when it passes the threshold the bonus is calculated.


New Member
Thanks that was a great help. I do need to find out how to enter locked reference in Structured references easier.


GraH - Guido

Well-Known Member
Glad I could help.
There is no easy like F4 key solution for structured references. You need to know the syntax. Using the intellisense does help me writing them.