Hi,
I'm trying to count the number of values within each closed interval (such that the upper and lower limits are included as well), however it yields 0.
Please find attached the Excel Spreadsheet with my attempt below, including the expected results as well.
This should give 2, since there are 2 values from rows 1-5 Columns A-L within that closed interval on A17 and B17.Please Login or Register to view this content.
Bookmarks