Forum Discussion
Search for date and then add cells in a column HELP
- in column B - eliminate first the #N/A .
if there is formula in B, use this =IFNA(YOUR FORMULA,"")
HTH
Lorenzo thank you for your reply.
Every cell in column B has this consecutive formula, but it's only a lookup to another sheet.
Cell B2 ='057 RD'!CS6
Cell B3 = ='057 RD'!CS7
Cell B4 = ='057 RD'!CS8 and so on.
The easiest solution would be delete the #N/A's from the other sheet, but this brings up a new problem in that the above formulas report a "0" if the cell in the other sheet is blank. I cannot have 0's in this column B.
GOT IT :-)
Thank you so much...
- glad it helped..
Lorenzo
Sorry to come back again, but it always seems that with Excel you get one thing working and another stops. So you and I have solved one problem but this has now led to the scatter graph showing "0" values even though there are none to see in the column. When I had #N/A as a value the scatter graph was able to view #N/A as a blank cell. But now using IFNA the graph is viewing the empty cell as a "0" zero.
Is there a way around this?
I am not familiar with graphs as I am more concentrated on records.
still, in the end of the =IFNA(YOUR FORMULA,"")
did you replace the "" with ZERO?how about replacing the "" with "x"?
I don't know if this will work.
if not, post this as a new conversation - there many good people here who can help you..
