G
guycummins
Is there a way to count the number of apples in column D that also have green
in column D?
in column D?
can I nest COUNTIF functions(C5:C8,"apples") AND (D5:D8,"green")
P
PCLIVE
Try this:
=SUMPRODUCT(--(C5:C8="apples"),--(D5
8="green"))
Does that help?
Paul
=SUMPRODUCT(--(C5:C8="apples"),--(D5
8="green"))Does that help?
Paul
D
Domenic
Try...
=SUMPRODUCT(--($C$5:$C$8="Apples"),--($D$5:$D$8="Green"))
Hope this helps!
=SUMPRODUCT(--($C$5:$C$8="Apples"),--($D$5:$D$8="Green"))
Hope this helps!
D
Dave
Hi,
Is the 2 mentions of column D a typo, or intended?
Dave.
Is the 2 mentions of column D a typo, or intended?
Dave.
G
guycummins
It was a typo Dave, thanks.
Dave said: