I'm trying to "count" How many items are assigned to a person a month. So I need the formula to look at every thing in Column A (A:A) and pick out all the ones that say Amina, then I need it to look at Column B (B:B) and only count (say True) for the items that were assigned on and between February 1 and February 28.
A B Desired Outcome
Shaniqua 2/2/2011 FALSE
Shaniqua 2/2/2011 FALSE
Shaniqua 2/2/2011 FALSE
Shaniqua 2/2/2011 FALSE
Amina 2/3/2011 TRUE
Amina 2/3/2011 TRUE
Kim 2/3/2011 FALSE
Kim 2/3/2011 FALSE
Kim 2/3/2011 FALSE
If you are using Excel 2003, as indicated by your profile, you will need SUMPRODUCT and you can use whole column references.
e.g.
=Sumproduct(--(A1:A100="Amina"),--(B1:B100>=Date(2011,2,1)),--(B1:B100<=Date(2011,2,28)),--(C1:C100=TRUE))
If you are using XL2007 or later, then you can use COUNTIFS and whole columnd.
=Countifs(A:A,"Amina",B:B,">="&Date(2011,2,1),B:B,"<="&Date(2011,2,28),C:C,TRUE)
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