Need a formula

Mike Curry

I am novice at best when it comes to anything related to formulas! I collect data in a grid format starting with a "Date Created" column. In a 24 hour period there are typically 50-60 entries. Each entry collects two points of data, in this case Weight and Gauge of material. Each column compares actual to a specification and is color coded red, green yellow. I created a separate grid that that I am filling out manually based on the collected information: Below is what I am manually collecting:

I need a formula to calculate this automatically.

Any help would be appreciated!

Paul Newcome

You need a formula to calculate what exactly?

Mike Curry

Below is how I collect the data. This happens 50+ times in a 24-hour period.

This is how I am compiling the data to chart. I need the below table to generate automatically. I am doing this manually, counting the number of above, below and on target etc.

Paul Newcome

To get a count from another sheet of rows that have multiple range/criteria sets, you would use a COUNTIFS.

=COUNTIFS({Gauge Column}, @cell < 0.95, {Date Column}, DATEONLY(@cell) = Date@row)