Conditional sum

[Andreas Håkansson]

Hi

I want to add the values of a column but only for the rows that are marked
with an x in the adjacent column. Like this

A B
1 x
2
3 x
4 x
5

and it should sum up to 8. How would I contruct a function like this ?

[Andreas Håkansson]

Sorry

Missd one vital point. I should ONLY include a row in the sum if the
adjacent column contains an x AND the value in the column is larger then 1.
So there's two conditions that has to be matched otherwise it would be a
sum.if


"Andreas Håkansson" <[email protected]> skrev i meddelandet
news:[email protected]...
> Hi
>
> I want to add the values of a column but only for the rows that are marked
> with an x in the adjacent column. Like this
>
> A B
> 1 x
> 2
> 3 x
> 4 x
> 5
>
> and it should sum up to 8. How would I contruct a function like this ?
>

[Biff]

Hi!

Try this:

=SUMPRODUCT(--(A1:A5>1),--(B1:B5="x"),A1:A5)

Biff

"Andreas Håkansson" <[email protected]> wrote in message
news:[email protected]...
> Hi
>
> I want to add the values of a column but only for the rows that are marked
> with an x in the adjacent column. Like this
>
> A B
> 1 x
> 2
> 3 x
> 4 x
> 5
>
> and it should sum up to 8. How would I contruct a function like this ?
>

[via135]

=SUMIF(B:B,"x",A:A)

-via135

Hi

I want to add the values of a column but only for the rows that are marked
with an x in the adjacent column. Like this

A B
1 x
2
3 x
4 x
5

and it should sum up to 8. How would I contruct a function like this ?

[Andreas Håkansson]

Thanks!

"Biff" <[email protected]> skrev i meddelandet
news:[email protected]...
> Hi!
>
> Try this:
>
> =SUMPRODUCT(--(A1:A5>1),--(B1:B5="x"),A1:A5)
>
> Biff
>
> "Andreas Håkansson" <[email protected]> wrote in message
> news:[email protected]...
>> Hi
>>
>> I want to add the values of a column but only for the rows that are
>> marked with an x in the adjacent column. Like this
>>
>> A B
>> 1 x
>> 2
>> 3 x
>> 4 x
>> 5
>>
>> and it should sum up to 8. How would I contruct a function like this ?
>>
>
>

[Biff]

You're welcome!

Biff

"Andreas Håkansson" <[email protected]> wrote in message
news:u%[email protected]...
> Thanks!
>
> "Biff" <[email protected]> skrev i meddelandet
> news:[email protected]...
>> Hi!
>>
>> Try this:
>>
>> =SUMPRODUCT(--(A1:A5>1),--(B1:B5="x"),A1:A5)
>>
>> Biff
>>
>> "Andreas Håkansson" <[email protected]> wrote in message
>> news:[email protected]...
>>> Hi
>>>
>>> I want to add the values of a column but only for the rows that are
>>> marked with an x in the adjacent column. Like this
>>>
>>> A B
>>> 1 x
>>> 2
>>> 3 x
>>> 4 x
>>> 5
>>>
>>> and it should sum up to 8. How would I contruct a function like this ?
>>>
>>
>>
>
>