| 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 | |||
![John[_64_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
