Count if
=COUNTIFS({Equipment Inspection Log - Webform Range 4}, "Good", {Equipment Inspection Log - Webform Range 2}, Description@row)
What am I doing wrong? my first range is multiple columns
Best Answers
-
My suggestion would be to add a column on the source sheet that counts how many cells are "Good" within the row and then in your other sheet the formula would be a SUMIFS that sums the counts in the helper column based on the description.
-
You would use an IF statement to say that IF the formula = 0, blank, otherwise run formula.
=IF(formula = 0, "", formula)
=IF(MIN(COLLECT({Equipment Inspection Log - Webform Range 6}, {Equipment Service Log - Webform Range 2}, Description@row)) = 0, "", MIN(COLLECT({Equipment Inspection Log - Webform Range 6}, {Equipment Service Log - Webform Range 2}, Description@row)))
Answers
-
Your range sizes and shapes must match, so if you have a range that is only a single column, then all ranges within the function must be a single column and the other way around. If you have multiple columns for a range then all ranges must be the same number of columns.
If the range size is the issue, can you provide more detail as to your layout and what exactly you are trying to acomplish?
-
Im trying to count multiple columns where the cell is "Good" if the description range matches the cell
-
My suggestion would be to add a column on the source sheet that counts how many cells are "Good" within the row and then in your other sheet the formula would be a SUMIFS that sums the counts in the helper column based on the description.
-
I went to the sheet and created a % score for the the columns I wanted. Now I want to show the minimum score for the description row. Thoughts? I cant make it work
=MIN(COLLECT({Equipment Inspection Log - Webform Range 6}), {Equipment Service Log - Webform Range 2}, Description@row)
-
It looks like you closed the COLLECT function too early. Move that closing parenthesis from after the first range to the end of the formula. That should get it working for you.
-
if it = 0, i want it to be blank, how do I make that happen?
-
I just want the 0% to be blank
-
You would use an IF statement to say that IF the formula = 0, blank, otherwise run formula.
=IF(formula = 0, "", formula)
=IF(MIN(COLLECT({Equipment Inspection Log - Webform Range 6}, {Equipment Service Log - Webform Range 2}, Description@row)) = 0, "", MIN(COLLECT({Equipment Inspection Log - Webform Range 6}, {Equipment Service Log - Webform Range 2}, Description@row)))
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.8K Get Help
- 406 Global Discussions
- 218 Industry Talk
- 457 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 297 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!