Question: Counting the number of times a specific word appears in any of 4 columns with a checked box on the same row.
I want to count the number of successful procedures. The procedures appear in any of columns I-L, and success is indicated by a checked box in column Q.
I can make it work for a single ‘block’ column (e.g. I or K or J) using COUNTIFS, but this does not work if I expend the reference values to include more than 1 column.
Any help or suggestions appreciated