Dear All,
Great forum - hope someone can help with this.

I have data in same workbook, different sheet arranged in cols with assigned NAMES to ranges.

For example; range PROD is a list of product documentation:
product1101_dispatched
product1101_invoice
product1102_dispatched
product1102_invoice

Range OLD is a list of deleted products:
product1000
product1000
product1001
product1000

I am trying to build a matrix where cells will first interogate OLD and if there is an entry return a D (for deleted). If no entry in OLD then interogate PROD and count the number of entries using productNumber* to count all the product documents associated with that product. Assumption is that products will appear in only one range or not at all. I will then conditional format matrix with traffic light red=0, orange=D,Green>0.

Am trying to use this (for prod1101):
{=IF(OLD="product1001","D",COUNTIF(PROD,"=product1101*"))}

Where am I going wrong ?

D:-)