LinkBack URL
About LinkBacks
Please help.
In Cell D1 I have a formula SUM(A1:C1)
If there are no entries I want D1 to be blank however if I enter 0,0,0 in cells A1:C1 then I want the formula to return 0 in D1.
What is the easiest way to do this?
Thanks
Please help.
In Cell D1 I have a formula SUM(A1:C1)
If there are no entries I want D1 to be blank however if I enter 0,0,0 in cells A1:C1 then I want the formula to return 0 in D1.
What is the easiest way to do this?
Thanks
Try
=IF(COUNTIF(A1:C1,0)=0,"",SUM(A1:C1))
Hi PaddyP,
Try this is D1
=IF(LEN(A1&B1&C1)=0,"",SUM(A1:C1))
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
Wow excellent. Thanks!
Here's another one...
=IF(COUNT(A1:C1),SUM(A1:C1),"")
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
Just an FYI the first suggestion does not work if you have a value other than zero in all three cells.
2nd and 3rd formulas work great!
Thanks again to everyone for your help. Solved!
Can't you format D1 to not show 0? I think the custom format is 0;-0;;
You're welcome. Thanks for the feedback!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks