I am trying to develop a length frequency table to graph. I am trying to count the number of data cells that fall within a length range for each year.The formula below is what I tried as an example, but encountered an error. D4:D18 are the cells with the length data (16-24), B4:B18 are the corresponding year cells (1980-1985) and K4 is the cell with the particular year (1980) in the length frequency table. Can anyone help with this error?
=COUNTIF(D4:D18,">=16.0"and(B4:B18=K4)) - COUNTIF(D4:D18,">18.0"and(B4:B18=K4))
Bookmarks