Ok, you obviously don't have the new functions yet, tryFormula:
=LET(f,FILTER($A$2:$J$21,$E$2:$E$21=N3),SUM(IF(f<>"",1,0)))
Ok, you obviously don't have the new functions yet, tryFormula:
=LET(f,FILTER($A$2:$J$21,$E$2:$E$21=N3),SUM(IF(f<>"",1,0)))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks