Sign in to join the conversation:
I am trying to COUNTIFS but have been unsuccessful so far. I need to count the status of a project if it is a certain product. I keep getting #INCORRECT
=COUNTIFS(Status3:Status51, "Green", Product:Product, "Rapid Test")
Thanks.
Hi eswartz,
You're seeing the error because your 2 ranges are different sizes. The first range is dealing with 49 rows, while the second is looking at the whole column.
If you change the formula to the following, you'll be good:
=COUNTIFS(Status:Status, "Green", Product:Product, "Rapid Test")
To add to the above
Or you can keep the same column ranges for both the columns
=COUNTIFS(Status3:Status51, "Green", Product3:Product51, "Rapid Test")
In the above image the green is the parent line, where some are calculating the child line %'s below, however in the lower half of the image it's not doing so. Any suggestions please? Thanks!
I have a checkbox column [H-SD (Added)[ with this formula: =IF([H-Supplier Type]@row = "Individual", IF(COUNTIF({SD-EmailPrimary}, [Email (Primary)]@row ) > 0, 1, 0), IF(COUNTIF({SD-EmailPrimary}, [Organization (Email)]@row ) > 0, 1, 0)) In another column, i want to evaluate if that column is checked or not, so I put this…
I have a sheet where I query 14 other sheets to collect all sorts of data (unique values from sheet into a column) and in another column I use an Index distinct collect to get all the unique value from those 14 columns, this is the 'Index' column. At some point a user will want to generate a certificate associted with the…
