Countif Problem
 

I am using

=countif((CE4:CE182+CF4:CF182)/CG4:CG182,"1")

And its not working, has anybody got any clues what I'm doing wrong?

Thanks in advance

i am afraid that
CE4:CE182+CF4:CF182)/CG4:CG182
does not return a range


--
Avner
------------------------------------------------------------------------
Avner's Profile: http://www.excelforum.com/member.php...fo&userid=5078
View this thread: http://www.excelforum.com/showthread...hreadid=275201

What is the intent if not

=SUMPRODUCT(--((CE4:CE182+CF4:CF182)/CG4:CG182)=1)

Alicia Wrote:
I am using

=countif((CE4:CE182+CF4:CF182)/CG4:CG182,"1")

And its not working, has anybody got any clues what I'm doing wrong?

Thanks in advance


--
Aladin Akyurek
------------------------------------------------------------------------
Aladin Akyurek's Profile: http://www.excelforum.com/member.php...fo&userid=4165
View this thread: http://www.excelforum.com/showthread...hreadid=275201

Hi,

What are you trying to do ?

Govind.

Alicia wrote:
I am using

=countif((CE4:CE182+CF4:CF182)/CG4:CG182,"1")

And its not working, has anybody got any clues what I'm doing wrong?

Thanks in advance