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.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.4K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 145 Just for fun
- 62 Community Job Board
- 463 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives