Hi,

Simple formula I am having a bit of trouble with.

In the workbook I am trying to summarise the data in the MAY sheet on the DATA sheet.

What is the right formula to use to count the number of instances a client has not renewed.

There are 7 reasons why and I would like to tally these up into the table on the DATA sheet.

I have tried SUMPRODUCT & COUNTIF but for some reason cannot get it to work.

Any help would be appreciated.
ThanksSample.xlsx