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 ?

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" skrev i meddelandet
...
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 ?

Hi!

Try this:

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

Biff

"Andreas Håkansson" wrote in message
...
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 ?

Thanks!

"Biff" skrev i meddelandet
...
Hi!

Try this:

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

Biff

"Andreas Håkansson" wrote in message
...
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 ?

You're welcome!

Biff

"Andreas Håkansson" wrote in message
...
Thanks!

"Biff" skrev i meddelandet
...
Hi!

Try this:

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

Biff

"Andreas Håkansson" wrote in message
...
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 ?

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

-via135



Andreas Håkansson Wrote:
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
------------------------------------------------------------------------
via135's Profile: http://www.excelforum.com/member.php...o&userid=26725
View this thread: http://www.excelforum.com/showthread...hreadid=526342