Hello Experts,
I want to write a formula in cell H5 that will look into cells A5, C5, E5 & G5 and return the sum of any number that is in these cells.
If however there are no numbers in these cells i want the formula to leave cell H5 empty. I do not want it to show Zero in cell H5 if there are no numbers in the cells to be summed.
Thanks,
Do you want H5 to be show as empty if there are no numbers in all of those cells or if any of them have no number?
Maybe this
Formula:
Please Login or Register to view this content.
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
Blank if all four cells are blank, otherwise show sum.
Formula:Please Login or Register to view this content.
Here is another way. I don't know what is between those cells so have listed them instead of using ranges.
Formula:Please Login or Register to view this content.
COUNT counts numbers. If alpha characters are entered in those cells, they are not counted...only numbers are counted. If there are no numbers in A5, C5, E5, G5 then the count is 0 and will return a blank cell. If any one of those cells contains a number then the SUM takes over and returns a total.
<---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.Ron W
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks