How to use the COUNTIF/COUNTIFS function for Non-Linear Cells?

Hello Matt,

Thanks for replying to my post. I've answered your questions below.

1. Example of what the raw data looks like (non-sensitive).  A sample file would be best.

I've provide a sample document with non sensitive data.

2. What are the actual formulas you are using?

A few of the formulas I've tried are as follows: =COUNTIFS(E29,E30,E49,E50,E64,">=5.00"). This formula returned 0 as a result even after testing one of the cells with the prescribed criteria.

The other formulas I've tried are =SUM(INDIRECT(COUNTIFS(E68,E67,E65,E61,E60,E59,E58,E44,E41,E39,E38,E35,E34,E33,E31,E20,E19,E15,E13,E9,E6,E5,E4,">=5.00"))). Looking at the table above, this formula returned an error (#REF) for 8th Graders and the same for 9th Graders.

3. A before and after mock up.  What are you doing now?  What is the expected end result?

Essentially I'd like to use a formula and receive results for non-linear cells. When selecting cells I'm looking to select cells that are not directly after one another.

Initially there wasn't a detailed breakdown for certain criteria. As these students move through the semester and school year, we are looking to obviously monitor their behavior with certain averages on a weekly basis. We are looking to get a deeper look at how students, at certain grade levels (6th - 12th), are performing behaviorally. Essentially after this data package is complete I'd like to present or have in place a detailed report of those that are performing within a certain criteria, i.e., 6th graders behavior score that are above a 3.00, greater than or equal to 5.00, or even below 2.00.  This data will be discussed with our school principal and teaching staff.

I hope you're able to help.  Let me know if you have any additional questions.