Thread: Can COUNTIF be nested to search two ranges
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jimbob Jimbob is offline
external usenet poster
  
Posts: 48
Default Can COUNTIF be nested to search two ranges
I need to use COUNTIF to search multiple ranges for combinations of answers

e.g Column A contains "colour", column B contains "shape"

I want to count how many blue circles there are etc...
Reply With QuoteReply With Quote