=IF(OR(AND('TEST DATA'!AD26:AE43<"",'TEST DATA'!Z26:Z43=""),'TEST
DATA'!AB26:AB43=""),1,"")

Thanks - sorry to be a pain - ive been trying to do this all day and my head
is spinning!!!

My end results need to fill in this on a summary sheet called SAR:

Ongoing Follow Ups New =
Ongoing Follow Ups Used =

and the data to be used is coming from separate worksheets called 1 - 31:

cell refs
Z26:Z43 (N) AB26:AB43 (N) AD26:AD43
AA26:AA43 (U) AC26:AC43 (U)

Dealt Hand Over Forward date
N U N U 14/05 etc

If there is a forward date then the customer will be an ongoing follow up
UNLESS there is a tick in the new or used Dealt or Handover boxes.

Ive got no nails left!!!!!

Carol



"CLR" wrote:

Copy and Paste your formula here, we'll take a look..........

Vaya con Dios,
Chuck, CABGx3



"englishrose4719" wrote:

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 ...........