Countif Problem

[Alicia]

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

 

[Avner]

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

 

[Aladin Akyurek]

What is the intent if not

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

 

[Govind]

Hi,

What are you trying to do ?

Govind.