Jeff

Posts: n/a

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?

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
COUNTIF using multiple conditions?	Muse of Fire	New Users to Excel	3	December 29th 04 08:49 PM
countif statement	Russell Hampton	Excel Worksheet Functions	6	December 18th 04 07:39 PM
setting two conditions for countif	Danny J	Excel Worksheet Functions	5	December 6th 04 11:49 PM
Countif - Countif	maswinney	Excel Worksheet Functions	3	November 15th 04 11:06 PM
countif, again	Liz G	Excel Worksheet Functions	2	November 1st 04 11:20 PM

All times are GMT +1. The time now is 03:33 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us