Counting entries and ignoring older than 6 months

Hello guys,

This is really hard to explain. I need a spreadsheet that counts the amount of times a name has been entered. But then I need it to ignore any that have been there longer than 6 months.

I used =(COUNTIF($A$5:$A$10000,A6)) to count the amount of times a name appears. But how can I make it ignore any that are older than 6 months?

excel.jpg

Thanks in advance

Try

=COUNTIF($A$5:$A$10000,A6,$B$5:$B$10000,">="&EDATE(TODAY(),-6))

Tried and it states that there are too many arguments to function :/

Sorry, it should be countifS

That worked! Wow thank you so much! Glad I signed up to this forum! Thanks for the help

You're welcome.