Count if columns is not empty and the range is within the date range

John Paul Jose

Im trying to make a formula work. My logic is to count the number of cells which the projectmanagers column is not blank and the projectmanagers row is edited in the last 7 days.

This is the formula im using but it keeps returning "#INCORRECT ARGUMENT SET"

any idea on what could I be doing wrong? Any help is appreciated. Thanks!

=COUNTIFS({project managers}, <>"", {modified}, >TODAY(-7))

John Paul Jose

This is solved now. I used a different column as reference as the project managers column is 3 columns in total with gaps and causing me problems in the formula. Thanks!

Genevieve P.

Hi @John Paul Jose

I'm glad you got this working! Thanks for posting your solution.

Cheers,

Genevieve