How to sum in an easy way?
 

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

How to sum in an easy way?
 

Hi,

can you use pivot table?

Regards,
Ivan

How to sum in an easy way?
 

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

How to sum in an easy way?
 

=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

How to sum in an easy way?
 

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

How to sum in an easy way?
 

=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.

How to sum in an easy way?
 

Thank's a lot Ardus!

How to sum in an easy way?
 

Bob Philip's solution is more flexible.

--
AP

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