Hi hopefully someone can put me out of my misery basically say you had a table with the following information
A B
1 Date Name
2 01/01/2001 Mike
3 02/01/2001 Mike
4 03/01/2001 Mike
Basically I want excel to count the amount Mike shows up in column B but only in the month of February. Can anyone help I’ve been working on it for hours and so far can only add up the total amount of text that appears in the entire of column B I cannot get the date part to work
Thank You in advance
Perhaps.
=sumproduct((month(a1:a100)=2)*(b1:b100="Mike"))
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
You can take a look at the attached file:
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
If year also matter, than go for below..
Formula:
Please Login or Register to view this content.
Regards!
=DEC2HEX(3563)
If you like someone's answer, click the star to give them a reputation point for that answer...
Please try this file.
Please click 'Add reputation', if my answer helped you.
Thank you all soo much. That was starting to drive me a little nuts. Working perfectly now.
You're Welcome and don't forget to mark thread as "Solved"
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks