Hi Eduardo,

Thanks for your reply.

I've tried SUMPRODUCT type formalas like this before but it comes up with
occurrences rather than the number of individuals. I did try your version
and added several other 'pairings' but unfortunately it only seemed throw up
occurrences.

All the best

Roy

"Eduardo" wrote:

Hi,
try

=SUMPRODUCT((A1:A7="Harm Red")*(B1:B7="Fully Ach"))

"Royegg" wrote:

I have a Excel 2007 Spreadsheet with 26 columns and 190 rows arranged as
follows:

A B C D E
F
1 Harm Red Fully Ach Abstinence Partly Ach Harm Red Fully Ach
2 Harm Red Fully Ach Harm Red Fully Ach
3 Harm Red Partly Ach
4 Abstinence Not Ach Harm Red Partly Ach
5 Abstinence Partly Ach
6 Harm Red Fully Ach Harm Red Partly Ach
7 Harm Red Fully Ach

Now I've been trying to use SUMPRODUCT and it only gives occurrences of say
'Harm Red' and 'Fully Ach'.

I need to be able to count individuals with at least one 'Harm Red' with a
'Fully Ach'. So in the example above there are 4 individuals (out of 7) with
at least one 'Harm Red' and 'Fully Ach' type of pairing even though there are
6 occurrences of this type of pairing.

I definitely need to be able to know how to arrive at the answer 4 through
Excel Worksheet Functions.

Could anybody help please!!

Thanking you in advance

All the best

Roy