-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Range of Days
- Thread starter ExcelRoy
- Start date
The COUNTIFS would work just fine but that requires you'd use double quotations around the "greater than or equal" symbols so I'd prefer something like
=SUMPRODUCT(--($AC$3:$AC$502>=1);--($AC$3:$AC$502<8))
With some minor adjustments the same formula can be used for the other two as well.
The formula above counts the number of values found in the rows but if it's the actual row numbers you're interested in just wrap the ranges in ROW()-function.
=SUMPRODUCT(--($AC$3:$AC$502>=1);--($AC$3:$AC$502<8))
With some minor adjustments the same formula can be used for the other two as well.
The formula above counts the number of values found in the rows but if it's the actual row numbers you're interested in just wrap the ranges in ROW()-function.
Upvote
0
