Cross Sheet AND Formula

Lindsay Kelley

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!

Antonio Figueroa

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

Antonio Figueroa

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

Lindsay Kelley

This works in pulling the data into another sheet? the formulas are not on the primary sheet.

Lindsay Kelley

I was able to do what you described as a temporary work around @Antonio thank you! Ill keep plugging away at an AND statement.