Array Formula- equal "House"

[Brad]

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

[Bob Phillips]

=sumif(A:A,"<>House",B:B)

no arrays necessary

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"Brad" <[email protected]> wrote in message
news:[email protected]...
> 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
>

[Brad]

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
>