Sorry guys but none of those worked. I think I need to explain further as
the responses do not seem to understand what I am trying to track here.

The people in columns A and B are grouped together by last names. There may
be one person, there may be 5+. For each group of people there will be only
one occurance of "yes" or "no" in column D. Despite only one yes or no,
wherever there is an occurance of yes I need to multiply that yes by the
number of people in that group. Hence why below I should return a value of 4
because there are three people with the name Doe and one with Smith but all
have a yes.

My original attempts with the countif and sometimes if commands were to
create the following formula: If D is yes, then count the number of
occurances of an ID number in column C that is greater than 1.

This is a monthly report and this database will be passed on to others
eventually, so I want to make it so that these fields to self calculate each
month based on the data entered.

I hope this helps to clarify.


"Joe" wrote:

I am trying to add the number of occurances of the word "yes" in one column,
and then adding the number of occurances of ID numbers in another. I will
try to give an example below:

A B C D
Doe John 12345 yes
Bob 12346
Ed 12347
Que Sue 23883 no
Mary 23884
Smith Joe 88464 yes

So basically what I want to do is wherever column D is yes, then I want it
to add up the number of ID numbers in column C and return a value (I am using
ID numbers as it is the best way to track). Thus based on the above, it
should return a value of 4.

I have been reviewing all the countif and sumproduct responses and trying
various things to no avail. Any suggestions?