thanks Peo - can you see my reply to Bob above?
"Peo Sjoblom" wrote:
If you mean a particu;ar month that you select (assume december 2004)
=SUMPRODUCT(--(MONTH(A2:A100)=12),--(YEAR(A2:A100)=2004),--(B2:B100="this_country"))
or if you mean the present month according to your computers clock
=SUMPRODUCT(--(MONTH(A2:A100)=MONTH(TODAY())),--(YEAR(A2:A100)=YEAR(TODAY())),--(B2:B100="this_country"))
Regards,
Peo Sjoblom
"Jeff" wrote:
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?
|