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