View Single Post
  #1   Report Post  
Jeff
 
Posts: n/a
Default How can I use COUNTIF to sum for two conditions?

I understand i have to use an array formula, but I don't know how!

I have an array listing dates when products arrived from diffferent
countries. I want to produce a chart which shows the number of arrivals for
each month from each country. COUNTIF will produce a total of arrivals for
each month, or a total from each country (ie for one condition) - but how
about for two conditions - this country in this month?