I want to use a formula (I'm under the impression 'countif' is the one) to count how many times two conditions are met in two different columns, i.e. to be able to calculate how many times April 2009 occurs when set out like this (month and year are in separate columns):
Month Year
April 2009
May 2005
June 2006
April 2009
April 2008
April 2009
Jan 2008
Jan 2007
April 2009
April 2008
So I want the formula to see that there Are 4 occasions when the condition of 'april' and '2009' are met and for this to be calculated on a different worksheet in the same workbook.
Any help is appreciated!
For multiple conditions you should use Sumproduct
something like:
=Sumproduct(--(A1:A10="April"),--(B1:B10=2009))
or if you want Countif, you would concatenate columns A and B in a separate column and then use Countif as normal.
Microsoft MVP - Excel
Where there is a will there are many ways. Pick One!
Please read the Forum Rules
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
Preferred Charities: Lupus Canada and Sick Kids Foundation.
Feel Free to Donate if you want to, for the assistance you received today.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks