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.