Cross Sheet AND Formula

Options

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!

Tags:

Best Answer

  • Antonio Figueroa
    Antonio Figueroa ✭✭✭✭✭✭
    Answer ✓
    Options

    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

  • Antonio Figueroa
    Antonio Figueroa ✭✭✭✭✭✭
    Answer ✓
    Options

    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
    Lindsay Kelley ✭✭✭✭
    Options

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

  • Lindsay Kelley
    Lindsay Kelley ✭✭✭✭
    Options

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