How to sum in an easy way?

[staeri]

I have the following sheet:

A | B | C
10 | 20 | 30
x | x | -

I would like to sum the second row (the one with values) for each
column that has the value "x" in the third row. In the example above
the sum should be 30 (10+20). How can I do that easily?

I have many columns after column C so I can't use a regular
IF-function.

Very grateful for fast response!

Regards,

S

 

[ivan.raiminius]

Hi,

can you use pivot table?

Regards,
Ivan

 

[staeri]

No, I can't. I need a formula.

 

[Ardus Petus]

=SUMIF(A2:C2,"x",A1:C1)

HTH

 

[robert111]

in A3 put if(a2="x",a1,0) then copy across whole row, then a sum of that
whole row will give you the required total.

 

[Bob Phillips]

=SUMIF(2:2,"x",1:1)

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

 

[staeri]

Thank's a lot Ardus!

 

[Ardus Petus]

Bob Philip's solution is more flexible.