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.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives