Thread: can I nest COUNTIF functions(C5:C8,"apples") AND (D5:D8,"green")
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Domenic[_2_] Domenic[_2_] is offline
external usenet poster
  
Posts: 265
Default 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?
Reply With QuoteReply With Quote