I'm looking to adjust this formula so that if the values in cells C12 and D12 are "" (blanks) then it will also be blank but if not, it will add up the values in C12 and D12.
Current formula I'm using and it still gives me "0" as the value if both C12 and D12 are blank
Two of my formulas that are looking for blanks before adding.
Please Login or Register to view this content.
Last edited by adrenom; 09-09-2016 at 04:58 PM.
Try this
Formula:
Please Login or Register to view this content.
This formula will return blank instead of 0 and SUM C11:D11 if not blank.
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
Maybe something like this...
=IF(COUNT(C11:D11)<2,"",C11+D11)
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks