Thread: Countif when you are wanting less than a cell.

Evening,

I am using this formula:

=COUNTIF('% Attend'!F:F,Table!$B3)

However I now need to amend it, so

1) to count the number of times a value of under 85 is in the column please

2) to count the number of times a value between 70 and 85 is in the column please.

Any help would be appreciated.

Thanks for this, I have one last task, if you could help it would be really appreciated:

I need to use:

=COUNTIF('% Attend'!F:F,"<85")

But only if value A4 is in column Q.

Any ideas please?

Thanks