Hi,

I have 30,000+ rows of order lines (extract from database). I have a report
setup that takes four criteria (retailer chain, order type, product group,
and brand) based on validation in B1:B4 from this I use an array formula with
SUMPRODUCT and four IF's (used since the criteria fields may be emty to allow
for alle variations of one or more of the criteria) to calculate a COGS,
GCBM, etc. for each of 26 sales reps. The criteria in B1:B4 are used much
like the page fields in a pivot table. In addition to this I would very much
like to have a count of distinct orders based on the four criteria. One order
can obviously have more than one orderline, so I can't just do a simple
count. How would I go about counting every unique order no. based on whatever
criteria are used?

Any thoughts? Does this even make sence to anyone but my good self? Thanks
you!

/Sune