Good morning,
I need a formula that will give me a null value if the sum adds up to zero.
I have also tried this
=IF(ISERROR(SUM(O4:Q4))," ",SUM(O4:Q4))
The reason I don't want the value of zero is because if the value 0 (Zero) are there then it counts in the rank, but i only want it to count if the rank if there is data and not zeros.=IF(Q3>0,SUM(O3:Q3)," ")
Thanks in advance
DJ
=if(sum(o4:q4)=0,"",sum(o4:q4))
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
That's done the trick. Thank you
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks