Conditional sum

A

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 ?
 
A

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
 
V

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 ?
Click to expand...
 
Top