Summing different columns if certain text is entered in a cell

[akkerfeld]

Hi!
I would like to summ data in different ranges if I enter a word or number into a cell.
e.g
I enter 3 into cell a1
This will summ cells b3,c3,e3, to cell a3
I enter 4 into cell a1
This will summ cells b3,d3,e3,g3 to cell a3.
Ofcourse I need to do this in several rows.

Any ideas how I could make this happen?

Thanks.

[akkerfeld]

I know someone out there is dieing to solve my problem.

[akkerfeld]

Last call for help!

[mangesh_yadav]

I guess you could simply have:

= if(a1=3,(b3+c3+e3),if(a1=4,(b3+d3+e3+g3),""))

and then drag it down.

- Mangesh

[akkerfeld]

Hi Mangesh!
Thanks for the tip, for some reason it says invalid formula.
I'll keep trying maybe I'm screwing up something.
Thx

[jenkins7890]

works for me.

[akkerfeld]

Thanks Jenkins,

Could be because I'm using different language version.
Althought it usually recognises the functions even if I enter them in english.
I'll have more time to work on it during the weekend.