| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Array Help?
I must have a brain cramp because I can't get the formula below to work. In
Column A I have items to buy, in Column B I have dollar amounts associated with each item, and in column D I have placed an "x" next to items as I purchase them. The formula below is in cell F2, and is designed to add all purchases, when an "x" is placed in column D. If there is a purchase amount in column B, without an "x" in Column D, than the formula shouldn't add the purchase amounts. What I have below (when entered as an array isn't working). Any help would be appreciated. Thanks, Dan =SUM(B2:B20)*(D2:D20="x") |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Array formula: how to join 2 ranges together to form one array? | Excel Worksheet Functions | |||
| Find specific value in array of array formula | Excel Worksheet Functions | |||
| Prevent cell/array references from changing when altering/moving thecell/array | Excel Discussion (Misc queries) | |||
| meaning of : IF(Switch; Average(array A, array B); array A) | Excel Worksheet Functions | |||
| combining cells and array from different sheets into an array to pass to IRR() | Excel Discussion (Misc queries) | |||
Threaded Mode
