Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
=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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
=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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
can you use multiple bin arrays in a frequency formula? | Excel Worksheet Functions | |||
Write a formula using two arrays, across two worksheets | Excel Worksheet Functions | |||
Arrays/Functions/Different datatypes in a formula? | Excel Worksheet Functions | |||
Using Vlookup in formula arrays | Excel Worksheet Functions | |||
formula question for arrays | Excel Programming |