Numpty Question of the day (counting rather than total on 2 sheets)

[Noodlesf1982]

Morning,

Can anyone help me please?

I need a formula to count how many lines of information there are, rather than add them up.

For example

On the sheet called 'Sales Progession' I want to count how many of the deals are at certain percentages, so that it looks like this.

40% 8
60% 22
80% 14
100% 6
Live 15

The information I require is on the 'CPA Pipeline' sheet column L

Any ideas?

 

[etaf]

you could use countif
=COUNTIF(A2:A100, ">="&B1)
this will count all the records in A2 to A100 (percentages) where they are greater or equal to a value in B1

 

[Noodlesf1982]

Thank you!