Bob,
I am back at it now. I did this formula on another project that I was able
to use it for. It was a success.

However, for the project that I am currently working on, it does not. I
wonder if there are specific criteria's that it is required to be successful?
I did simple countif to see what it is doing. Where it should be giving me
zero, it is giving me 1, not sure why? I am baffled now.

Any suggestions?
RJ

"Bob Phillips" wrote:

Do you mean

=IF(COUNTIF('SouceA'!$AG$2:$AG$918,$B47)=0,"No
pricing",SUMIF('SouceA'!$AG$2:$AG$918,$B47,'Source A'!$AL$2:$AL$918))


--
__________________________________
HTH

Bob

"MrRJ" wrote in message
...
I am trying to resolve a simple problem. I do not want to see the return
value of #N/A because it interupts when I do a sumation. I am using this
formula, which is part of another formula that I am using. This is the
part
this is giving me grief.

=SUMIF('SouceA'!$AG$2:$AG$918,$B47,'SourceA'!$AL$2 :$AL$918)

Note that I am looking for a value in SourceA but it is not there. Which
is
ok. I want to return a value or a statement to something like this "No
pricing" if there is no value. Because it is those that I will be looking
for in my analysis.

Thanks,
RJ