Thanks Chuck - i tried it but now there is a VALUE error coming up.

Any ideas?
Carol


"CLR" wrote:

Try this.......

=IF(OR(AND(Sheet1!A20<"",Sheet1!A16=""),Sheet1!A1 7=""),1,"")

Just change the Sheet1 to whatever sheet number you want the calculations
done for.

hth
Vaya con Dios,
Chuck, CABGx3



"englishrose4719" wrote:

How do I work this one out please?

IF 'A20' is not null AND 'A16' is null OR 'A17' is null then COUNT result in
'A14' on a different spreadsheet!!!!!

help me please ...........