Apologies - I should have said that each name in my data has some letters
after it, hence 'Debbie Storr-CDM' in the formula (I should have added this
to my example below)

"Kate" wrote:

Please help - I have spent 4 hrs trying to work out where I have gone wrong
with this!

I have a large set of data on a tab called 'data'. It is over 60 columns by
523 rows. I would like to do some counts based on what is in 3 columns of
data. A section of it is shown below:

Lead Type Name Closed Reason
Saleslinq Charlotte Fryer Existing Customer
Redpoint Debbie Storr Not Interested
Exhibition Nigel Aldridge No to Company
Saleslinq Debbie Storr Existing Customer
Exhibition Charlotte Fryer Not Interested

There are several columns of data inbetween the above I have shown. I would
like to do a sum to find out how many rows of data have a lead type of
'Saleslinq', the name of 'Debbie Storr' and the Closed Reason of 'Existing
Customer'. I would expect to get a result from the above of '1'

I have used the following formula
=SUMPRODUCT(--(Data!R2:R523="Debbie Storr-CDM"),--(Data!V2:V523="Existing
Customer"),--(Data!DB2:DB523="Saleslinq"))

Week on week, I get new data and paste over and have never had a problem
with this formula. However, this week, all my sums have turned to '#N/A'. I
have checked the formatting of the data, done some text to columns just to be
sure and it still doesn't give me a result.

When I try to use the conditional sum wizard it tells me the formula I have
is too long as I have too many criterias.

Thanks
Kate