cancel
Showing results for 
Search instead for 
Did you mean: 

How to Count Values

Former Member
0 Kudos

Hi,

How to COUNT Range values in Xcelsius or in MS EXCEL

My data is like this

Diff %

-87.54

-97.22

4.53

5.86

14.16

25.47

in this i want to count values like

1) diff% < 0

2) 0<=diff%<6

3) diff%>=6

how can i calculate this one.

can any one help me

Regards,

Raj

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi,

You can try the below one

Solution



	Count <0	>=0 and <6	>=6
-87.54%	2	2	0
-97.22%			
4.53%			
5.86%			
14.16%			
25.47%			

	Count <0	>=0 and <6	>=6
-0.8754	=COUNTIF($D$11:$D$16,"<0")	=ABS(COUNTIF($D$11:$D$16,">=0")-COUNTIF(D11:D16,"<6"))	=COUNTIF($D$11:$D$16,">=6")
-0.9722			
0.0453			
0.0586			
0.1416			
0.2547			

If you are using excel 2007 then you can use COUNTIFS() for multiple comparissions.

Regards,

Anjanikumar C.A.

Former Member
0 Kudos

hi Anjan,

ThanQ so much for ur quick response.

and it is working.

i hope u will continue ur quick response.

Regards,

Raj