Forum Discussion
IFNA Blank Cell Output?
Good-morning! This is my first time posting here. I have a question regarding replacing N/A with blank cells. I am using the IFNA function to replace N/A values returned from VLOOKUP with blank ce...
It really depends on the actual cells and formulas, but you might use something like
=IF(COUNTIF(range, "")=COUNTA(range), "", SUM(range)
Hi,
Just wanted to let you know I was able to use the info you provided to come up with a solution. Basically I created a formula that "counts the number of blank cells in the range of interest & when that count does not equal the total number of cells in that range, the range is summed, otherwise a blank value is returned". This is similar to what you said, only I manually entered the number of cells in the range. Like this:
=IF(COUNTIF(A2:C2,"")<>3,SUM(A2:C2),"")
Thanks again - you were a life saver!
Just wanted to let you know I was able to use the info you provided to come up with a solution. Basically I created a formula that "counts the number of blank cells in the range of interest & when that count does not equal the total number of cells in that range, the range is summed, otherwise a blank value is returned". This is similar to what you said, only I manually entered the number of cells in the range. Like this:
=IF(COUNTIF(A2:C2,"")<>3,SUM(A2:C2),"")
Thanks again - you were a life saver!