=SUMPRODUCT(--($C$2:$C$12336=C1),--($D$2:$D$12336=D1))

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Jaydubs" wrote in message
...
Hello fellow Excellians,

On my last question I got a perfect answer. I wanted to know how many
times
a particular value could be found in a certain column in a certain tab.

Now I want to know how I can use the same by selecting two values. I have
a
sheet with the following values.

Date In (Column A)
Number (Column B)
Solved by (Column C)
Flow (Column D)
Cause (Column E)
etc, etc

Now I want to know how many times the person (in Column C) has solved a
particalur issue concerning a Flow (Column D). With selecting only one
value
(for the situation how many times does a certain person solve an issue you
will use the following statement =COUNTIF($F$2:$F$12336;c1) ). But how do
you
include an and in this statement as you make a selection on two different
values.

I will be very gratefull for your answer.

--
** Fool on the hill **