can I nest COUNTIF functions(C5:C8,"apples") AND (D5:D8,"green")
 

Is there a way to count the number of apples in column D that also have green
in column D?

can I nest COUNTIF functions(C5:C8,"apples") AND (D5:D8,"green")
 

Try this:

=SUMPRODUCT(--(C5:C8="apples"),--(D5:D8="green"))

Does that help?
Paul

--

"guycummins" wrote in message
...
Is there a way to count the number of apples in column D that also have
green
in column D?

can I nest COUNTIF functions(C5:C8,"apples") AND (D5:D8,"green")
 

Try...

=SUMPRODUCT(--($C$5:$C$8="Apples"),--($D$5:$D$8="Green"))

Hope this helps!

In article ,
guycummins wrote:

Is there a way to count the number of apples in column D that also have green
in column D?

can I nest COUNTIF functions(C5:C8,"apples") AND (D5:D8,"green")
 

Hi,
Is the 2 mentions of column D a typo, or intended?
Dave.

"guycummins" wrote:

Is there a way to count the number of apples in column D that also have green
in column D?

can I nest COUNTIF functions(C5:C8,"apples") AND (D5:D8,"green
 

It was a typo Dave, thanks.

"Dave" wrote:

Hi,
Is the 2 mentions of column D a typo, or intended?
Dave.

"guycummins" wrote:

Is there a way to count the number of apples in column D that also have green
in column D?