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

Hi,

can you use pivot table?

Regards,
Ivan

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

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

HTH
--
AP

a écrit dans le message de
oups.com...
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

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.


--
robert111
------------------------------------------------------------------------
robert111's Profile: http://www.excelforum.com/member.php...o&userid=31996
View this thread: http://www.excelforum.com/showthread...hreadid=534481

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

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

wrote in message
ps.com...
No, I can't. I need a formula.

Thank's a lot Ardus!

Bob Philip's solution is more flexible.

--
AP

a écrit dans le message de
oups.com...
Thank's a lot Ardus!