=sum formula using arrays
Column A contains numbers, such as:
6,000
9,000
8,000
I want to sum column A, but if a number is greater than 7,000, I only want
7,000 included in my sum. The result of the above amounts I am looking for
is 20,000. I think I need an array formula, but not sure what the formula
is. Thanks
|