I'm trying to get a count of specific cell with specific dates... not exactly sure how to write this formula... Here's what I got.
Column A Column B
2012-01-02 Dog
2012-01-12 Dog
2012-03-25 Cat
2012-05-25 Dog
I need a formula that will count how many Dogs in January.
Try (untested)
=SUMPRODUCT(--MONTH(A1:A4=1)*(B1:B4="Dog"))
Regards
Special-K
Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.
With Excel 2003 SUMPRODUCT is your friend for this. See attached.
If using Excel 2007 or later, you could use COUNTIFS.
Rather than hardcode dates into the formula I've added a start and end date cell. This makes it easier when things need updating further down the line.
If I've been of help, please hit the star
And, last but not least, use a Pivot Table
You should have tested!Originally Posted by Special-K
Try it like this:
=SUMPRODUCT(--(MONTH(A1:A4)=1),--(B1:B4="Dog"))
Assumes no empty cells in the date column.
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks