Count distinct IDs based on Category and timeframe

I need a formula to count distinct IDs based on category and the date the category was added is less than 30 days 

Data structure: 

Column F – list of IDs

Column L – categories (a category can repeat)

Column P – the date the category was added

Tried this: 

=SUMIFS(‘Intervention Aging’!F:F,’Intervention Aging’!L:L,”Medication”,’Intervention Aging’!P:P,”>=&TODAY()-30″)

By: Roseanna

Leave a Reply

Your email address will not be published. Required fields are marked *