Hi,
I just found the way!
or![]()
=COUNTIFS(INDIRECT("Table1[Name]");$I$3;INDIRECT("Table1[sDate]");"<="&$I$4;INDIRECT("Table1[eDate]");">="&$I$5)
Regards,![]()
=SUM((INDIRECT("Table1[Name]")=$I$3)*(INDIRECT("Table1[sDate]")<=$I$4)*(INDIRECT("Table1[eDate]")>=$I$5))
Elio Fernandes
Bookmarks