Well just shout if you need any more.

--
__________________________________
HTH

Bob

"MrRJ" wrote in message
...
Never mind, I think I figured it out. My mind is going.

"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