Count if in a range by year

[Ryleigh]

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))

[JBeaucaire]

You can't just slip the word "and" into the middle of a COUNTIF. If you have more than one criteria... use COUNTIFS().

=COUNTIFS(D4:D18, ">=16.0", D4:D18, "<18.0", B4:B16, K4)

[Pepe Le Mokko]

Try

Please Login or Register  to view this content.

[ben_hensel]

=COUNTIFS(d4:d18, ">=16", b4:b18, =k4) - COUNTIFS(d4:d18, ">18", b4:b18, =k4)

[Ryleigh]

You can't just slip the word "and" into the middle of a COUNTIF. If you have more than one criteria... use COUNTIFS().

=COUNTIFS(D4:D18, ">=16.0", D4:D18, "<18.0", B4:B16, K4)

Thanks for the help, this worked perfectly.