=sum formula using arrays
Hi
try the following array formula
=SUM(IF(A1:A37000,7000,A1:A3))
--
Regards
Frank Kabel
Frankfurt, Germany
John wrote:
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
|