Is there a way to add to this to say if it = 0 then 0 else blank ?
=IF(SUM(D19:D25)=0,"0",SUM(D19:D25))
Thanks for your help in advance last peice of this excel sheet I wont have to touch again =)
Is there a way to add to this to say if it = 0 then 0 else blank ?
=IF(SUM(D19:D25)=0,"0",SUM(D19:D25))
Thanks for your help in advance last peice of this excel sheet I wont have to touch again =)
You do not need to put the 0 in quotes, unless there is a specific need for the 0 to be a text 0, rather than the number 0.
=IF(SUM(D19:D25)=0,0,SUM(D19:D25))
Please clarify your question. To me it sounds like you want this:
=IF(SUM(D19:D25)=0,0,"")
But this doesn't make sense to me because then why sum at all?
=IF(SUM(D19:D25)=0,"",SUM(D19:D25))
I have cells d19 to d25 that have numbers ranging 0-9 and what I would like is celld18 to give me the sum, but if that sum is 0 then show 0, but at times the cells can be blank so if the cells are blank show blank
So, if all the cells in the range are blank, you want it to be blank?
=IF(COUNTA(D19:D25)=0,"",SUM(D19:D25))
1 gold star...yup..Thanks a ton
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks