Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Array Formula
Thanks for taking the time to read my question.
I have 2 columns, and I want to add the second column where the first column doesn't equal "House" Car 100 Gas 90 House 300 Saving 100 -------------- Total 290 I want to be able to sort the data alphabetically, or by value. If you make static references, the formulas I am trying to use fail. I know an array would work perfectly here, I just can't seem to find the formula that would work. Thanks, Brad |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Array Formula
=sumif(A:A,"<House",B:B)
no arrays necessary -- HTH Bob Phillips (remove nothere from the email address if mailing direct) "Brad" wrote in message ... Thanks for taking the time to read my question. I have 2 columns, and I want to add the second column where the first column doesn't equal "House" Car 100 Gas 90 House 300 Saving 100 -------------- Total 290 I want to be able to sort the data alphabetically, or by value. If you make static references, the formulas I am trying to use fail. I know an array would work perfectly here, I just can't seem to find the formula that would work. Thanks, Brad |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Array Formula
Found some proper help online.
{=SUM(IF(A7:A18<"House",B7:B18))} Thanks, Brad "Brad" wrote: Thanks for taking the time to read my question. I have 2 columns, and I want to add the second column where the first column doesn't equal "House" Car 100 Gas 90 House 300 Saving 100 -------------- Total 290 I want to be able to sort the data alphabetically, or by value. If you make static references, the formulas I am trying to use fail. I know an array would work perfectly here, I just can't seem to find the formula that would work. Thanks, Brad |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Array Formula Not Working with Range with Formulas | Excel Discussion (Misc queries) | |||
Array formula returning wrong results | Excel Discussion (Misc queries) | |||
Suppress array formula #NA | Excel Worksheet Functions | |||
problem with Array Formula | Excel Worksheet Functions | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) |