As the title says, I need help with for instance making this COUNTIFS formula:
=COUNTIFS($B$2:B2843;B2843; $C$2:C2843;C2843) to display as blank if the red criteria cells are blank. In the sheet, columns MNO are variations of this formula, and column P uses a COUNTIFS to check if the Part number (in column C) exists also in another sheet (to check if an inspected part is on the actual inspection list).
Sorry in advance, as this is quite an advanced excel sheet from the start, but I've tried to shorten down and remove any irrelevant information. You would only need to solve this issue for the O column for instance, and the idea would most likely apply to all other columns. Feel free to hide columns J,M,N and P also, just to solve the O column. Here's a picture of the filtered sheet:
2.png
In the picture below you can see how it looks at the moment with all relevant columns visible when I copy these formulas downwards. They function just fine, but I'd like them to be blank if nothing else is written on the line in the C column.
1.png
I've tried making another =IF(formula;formula;"") but that doesn't work with an already existing COUNTIFS. And I've tried conditional formatting to where I can make the row display transparent text if the row's C cell is blank, but haven't managed that to work.
The excel sheet is attached.
Any ideas?
(Just an explanation of the columns:
- M counts the number of consequtive 'Positive' inspections.
- N counts the total amount of 'Negative' inspections.
- O counts the total amount of inspections.
- P checks to see if the inspected part number on the LOG is on our Inspection List sheet.)
Bookmarks