Hi,
I have the following code that is working ok
I need to change so that I can use it in conditional formatting.![]()
{=SUM((tbPlanner[Name]="Orlando")*(tbPlanner[sDate]<=E24)*(tbPlanner[eDate]>=E24))}
I tried to use INDIRECT but I am having some problems because I am not used to work with it. I' ve been thinking to use COUNTIFS instead of SUM.
Any help would be great!
Regards,
Elio Fernandes
Bookmarks