how to count +ve and -ve no.

[manojbk]

i have both positive and negative no . in column d . i want to count them separatelly . I would be thankful , if some one can help me in this matter.

 

[shyrath]

Try Sumif

(nb you may need to change ; in the formula to ,)

Excel Workbook
	C	D
4		-2
5		1
6		-2
7		2
8	SUMIF >0	3
9	SUMIF	-4
menu

 

[manojbk]

Sorry, it is not working . it is showing that formula contain some error like that. please help me...

 

[shyrath]

Did you replace the ; with , ?

LIke: =SUMIF(D4:D7,">0",D4:D7)

 

[manojbk]

I did it but, still it is not working

 

[shyrath]

Can you post an example with excel jeanie, see front page

 

[pgc01]

Hi

Try:

=COUNTIF(D:D,">0")

to count how many positive numbers in column D.

 

[Krishnakumar]

Hi,

Try COUNTIF

=COUNTIF(D2:D10,">0")

HTH

 

[manojbk]

Thank u gentlemen thank u very much..