Cross Sheet AND Formula
Hello!
Trying to put together a formula looking at two columns on a different sheet. the Logic is if, Range 5 is blank and Range 4 is blank = number. Keep getting unparesable. =COUNTIF({Tracker Range 5}, "", AND{Tracker Range 4}, "")
Thoughts?
thanks!
Best Answer
-
You can resolve this by adding a helper column and add the characters together.
On your sheet with the two columns that you are trying to look at. Add a column and use this formula
=LEN([Column7]@row) + LEN([Column8]@row) of coarse use your column names
and then convert to column formula
this will make the range 5 and the range 4 that is blank equal a 0.
and the ones that are not blank it will count the characters.
will this help
Answers
-
You can resolve this by adding a helper column and add the characters together.
On your sheet with the two columns that you are trying to look at. Add a column and use this formula
=LEN([Column7]@row) + LEN([Column8]@row) of coarse use your column names
and then convert to column formula
this will make the range 5 and the range 4 that is blank equal a 0.
and the ones that are not blank it will count the characters.
will this help
-
This works in pulling the data into another sheet? the formulas are not on the primary sheet.
-
I was able to do what you described as a temporary work around @Antonio thank you! Ill keep plugging away at an AND statement.
