If and CountIf help

[professor.x]

This is a formula that I have, but it's not quite doing what I want it to:

=IF($G$2:$G$100>DATE(YEAR(TODAY())-1,MONTH(TODAY()),DAY(TODAY())),COUNTIFS($H$2:$H$100,"Person A"),"")


I only want it to count the criteria only if the adjacent G cell is equal to or less than 1 year to today's date.

So it pretty has to be where a cell in column g is equal to or less than 1 year to today's date AND the adjacent h column equals the criteria set.

Any help is greatly appreciated.

 

[Jonmo1]

Try

=SUMPRODUCT(--($G$2:$G$100>DATE(YEAR(TODAY())-1,MONTH(TODAY()),DAY(TODAY()))),--($H$2:$H$100="Person A"))


Hope that helps.

 

[professor.x]

Thanks for the help Jonmo. So far it works.