Thread: can I nest COUNTIF functions(C5:C8,"apples") AND (D5:D8,"green")
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
PCLIVE PCLIVE is offline
external usenet poster
  
Posts: 1,311
Default 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?



Reply With QuoteReply With Quote