Count data > 100%

[ExcelRoy]

Hi,

I am trying to count from N15:N64 what is greater than 100%

Not sure how to achieve this, was trying
=SUM(N15:N64 >100 )
but not sure how to implement the >100%

Any help appreciated

Thanks

 

[gnaga]

Are you trying to COUNT the data >100 or SUM the data >100?

 

[CA_Punit]

Deleted

 

[CA_Punit]

Count Sequential Time.xlsx
	B	C
3	1	101%
4	2	99%
5	4	89%
6	4	102%
7	4	104%
8
9		3
Sum greater than 100%

Cell Formulas
Range	Formula
C9	C9	=COUNTIFS(C3:C7,">"&1)

 

[gnaga]

 

[gaz_chops]

To count try

=COUNTIFS($N$15:$N$64,">"&100%)

 

[ExcelRoy]

Hi gnaga,

I am trying to count the rows that exceed 100%

Hi CA_Punit,

No need for the addition of column B

Thanks

 

[ExcelRoy]

Perfect gaz_chops, many thanks

 

[gaz_chops]

You're welcome, thanks for the feedback.

 

[CA_Punit]

Column B had no use, I inserted just you required SUM..