Share via

Counting values in multiple rows in excel using COUNTIFS

Anonymous
2017-08-14T22:34:55+00:00

I am trying to count how many cells in the red boxes are over 2 hours and how many are exactly 0 hours. When I use the COUNTIFS function with the shown formula in the red box with yellow highlight returns a #VALUE error. I changed the formula so the counted cells are the same size among each range for the Months but that returns a 0 result.

What I'm trying to accomplish is below. The red box in the bottom section is what I would like to accomplish without having to calculate each month individually then summing them at the bottom.

Is there a way I can count how many days are over 2 hours and how many are exactly 0 without having to count each month individually and then creating a SUM formula to get the total for the season?

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2017-08-14T23:01:59+00:00

    Impossible to see the worksheets - too small

    Please post file to OneDrive or Dropbox and tell us the link

    best wishes

    Was this answer helpful?

    0 comments