I have an excel sheet Where Cell Value Of A1=5,Cell Value Of B1=6,Cell Value Of C1=2,Cell Value Of D1=4,Cell Value Of E1=1,and in Cell Value Of F1=A1+B1C1D1E1=4. Again Cell Value Of A2=4(Repeat of Cell Value Of F1)
now if Cell Value Of B2=0,Cell Value Of C2=0,Cell Value Of D2=0,Cell Value Of E2=0 Then Cell Value Of F2 will be Cell Value Of A2
But i need a formula by which if Cell Value Of B2=0,Cell Value Of C2=0,Cell Value Of D2=0,Cell Value Of E2=0 Then Cell Value Of F2 will be does not appaer as Cell Value Of A2
Hope Your kind solicitation in this regard will help me to solve my problem
With Heartiest thanks to all of You of this FORUM
tarun@1964
EXCEL FORMULA

 Lounger
 Posts: 33
 Joined: 10 Jun 2022, 09:22
 Location: KOLKATA , WEST BENGAL, INDIA

 Administrator
 Posts: 79561
 Joined: 16 Jan 2010, 00:14
 Status: Microsoft MVP
 Location: Wageningen, The Netherlands
Re: EXCEL FORMULA
Change the formula in F1 to
=IF(AND(B1:E1=0), "", SUM(A1:B1)SUM(C1:E1))
Then fill down.
=IF(AND(B1:E1=0), "", SUM(A1:B1)SUM(C1:E1))
Then fill down.
Best wishes,
Hans
Hans

 Lounger
 Posts: 33
 Joined: 10 Jun 2022, 09:22
 Location: KOLKATA , WEST BENGAL, INDIA
Re: EXCEL FORMULA
Respected Hans Vogelar Sir, thanks You for Your Suggestion , i have used it but Cell Value F1 is showing #VALUE! and repeat it in down row
Hope Your kind solicitation in this regard will help me to solve my problem
With Heartiest thanks to all of You of this FORUM
tarun@1964
Hope Your kind solicitation in this regard will help me to solve my problem
With Heartiest thanks to all of You of this FORUM
tarun@1964
You do not have the required permissions to view the files attached to this post.

 5StarLounger
 Posts: 826
 Joined: 24 Jan 2010, 15:56

 Lounger
 Posts: 33
 Joined: 10 Jun 2022, 09:22
 Location: KOLKATA , WEST BENGAL, INDIA
Re: EXCEL FORMULA
Respected Rory, there is no @ Symbol in formula in my workbook

 Lounger
 Posts: 33
 Joined: 10 Jun 2022, 09:22
 Location: KOLKATA , WEST BENGAL, INDIA
Re: EXCEL FORMULA
Respected Rory, there is no @ Symbol in formula in my workbook
Regards,
tarun@1964
Regards,
tarun@1964

 Administrator
 Posts: 12833
 Joined: 16 Jan 2010, 15:49
 Location: London, Europe
Re: EXCEL FORMULA
Remove this @ symbol
You do not have the required permissions to view the files attached to this post.
StuartR

 5StarLounger
 Posts: 826
 Joined: 24 Jan 2010, 15:56

 Lounger
 Posts: 33
 Joined: 10 Jun 2022, 09:22
 Location: KOLKATA , WEST BENGAL, INDIA
Re: EXCEL FORMULA
Respected Rory, and Respected StuartR, Sir,
i am attaching Screen Picture of my Excel workbook where i have used formula
=IF(AND(B1:E1=0), "", SUM(A1:B1)SUM(C1:E1))
With heartiest Regards to all of You,
tarun@1964
i am attaching Screen Picture of my Excel workbook where i have used formula
=IF(AND(B1:E1=0), "", SUM(A1:B1)SUM(C1:E1))
With heartiest Regards to all of You,
tarun@1964
You do not have the required permissions to view the files attached to this post.

 Administrator
 Posts: 79561
 Joined: 16 Jan 2010, 00:14
 Status: Microsoft MVP
 Location: Wageningen, The Netherlands
Re: EXCEL FORMULA
How about the attached version?
You do not have the required permissions to view the files attached to this post.
Best wishes,
Hans
Hans

 5StarLounger
 Posts: 826
 Joined: 24 Jan 2010, 15:56
Re: EXCEL FORMULA
You probably need to use Ctrl+Shift+Enter in your version. Or, if you just want to ignore empty cells as in your example:
=IF(COUNT(B1:E1)<>4, "", SUM(A1:B1)SUM(C1:E1))
=IF(COUNT(B1:E1)<>4, "", SUM(A1:B1)SUM(C1:E1))
Regards,
Rory
Rory

 Lounger
 Posts: 33
 Joined: 10 Jun 2022, 09:22
 Location: KOLKATA , WEST BENGAL, INDIA
Re: EXCEL FORMULA
Respected Sir, my attached version is MS 13 and i am using WINDOWS  7
Hope Your Kind Solicitation will help me to solve my problem
With heartiest Regards to all of You,
tarun@1964
Hope Your Kind Solicitation will help me to solve my problem
With heartiest Regards to all of You,
tarun@1964
You do not have the required permissions to view the files attached to this post.

 Administrator
 Posts: 79561
 Joined: 16 Jan 2010, 00:14
 Status: Microsoft MVP
 Location: Wageningen, The Netherlands
Re: EXCEL FORMULA
Using Rory's suggestion:
You do not have the required permissions to view the files attached to this post.
Best wishes,
Hans
Hans