In my work I take around 100 different measurements. Each measurement has it's own spec for high and low tolerance. For example measurement #1 can be between 0 and 1. Measurement #4 could be between 0 and 1.5 and so on. I use conditional formatting to highlight the measurements that are out of spec, but then I have to manually count each highlighted cell to give an overall report. I'm wondering it I could automate the process to give me a total count of each out of spec measurement. I'm wondering if anyone has suggestions on how I can do that. I have an example below on how the spreadsheet is organized. Keep in mind that I can't reorganize any of the measurements and this is only a small example of the 100 measurements that are done.