formula gives result only if condition is satisfied, otherwise empty cell

Dear experts,
I am struggling with a sheet which have a formula in C column but it does not appears, it only appears when value in respective cell D is "y" as shown. I do not know how to apply this condition.Any help or clue is greatly appreciated!
A-----------------B-----------------C-----------------------------------D
1-----------------2----------=if($D1="y",sum($A1:$B1))------------------y
5-----------------4----------=if($D2="y",sum($A2:$B2))------------------y
6-----------------7-----------no formula-------------------------------- n
8-----------------2----------=if($D4="y",sum($A4:$B4))------------------y
and so on
....

Hi shaukat

I don't understand what you mean "is not appears".

For me it's appears.

I make an example for you.

Let us know where is the problem, using the example Sheet.

=if($D1="y",sum($A1:$B1))

Do you mean:

=if($D1="y",sum($A1:$B1),"")


Regards, TMS

Hi shaukat

I mean how to make the formula auto-fill when condition is satisfied, normally I have to drag formula down to the end

Yes! This is the way to go on... And don't forget to use the $ symbl, as TMShucks, proposed you.


=IF($D1="y";SUM($A1:$B1);"")


Hope to helps you.

shaukat, when we "write" a formula in Excel. we use semicolon.

In your example, i just fill the last cell...

Is it OK now?

Glad to helps you


Also:

Mark your post [SOLVED] if it has been answered satisfactorily.
To do this, click EDIT in your original post, click GO ADVANCED and set the PREFIX. It helps everybody!

If you are satisfied by any members response to your problem, please click the star icon *of their post to show your appreciation.