thetheaterimp
New Member
- Joined
- Oct 24, 2011
- Messages
- 2
So I want to be able to count all instances of a persons name in Column A that have a date of a week old in Column B.
I know I can accomplish just the date counting with this formula:
=COUNTIF(B:B,"<="&(TODAY()-7))
Though I dont know how to expand on this so it only counts those that meet that criteria for a persons name.
Thanks in advance!
I know I can accomplish just the date counting with this formula:
=COUNTIF(B:B,"<="&(TODAY()-7))
Though I dont know how to expand on this so it only counts those that meet that criteria for a persons name.
Thanks in advance!