LinkBack URL
About LinkBacks
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.
You should have tested!
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
Register To Reply
Bookmarks