Forum Discussion
Countifs done in multiples
Hello, We are new to this community, but not without experience in excel. Our club has recently done a survey of our members, and we are trying to find when people are available and which of ...
When one more variant with keeping asterisks as it is, the only point to correct misprint Satuday* -> Saturday*.
=SUMPRODUCT( (ISNUMBER(SEARCH(LEFT(F$32,LEN(F$32)-1),OFFSET($B$1,0,0,COUNTA($B:$B)+5))))* (ISNUMBER(SEARCH(LEFT($E33,LEN($E33)-1),OFFSET($C$1,0,0,COUNTA($B:$B)+5)))) )
I added OFFSET here to improve performance, that could be $B:$B and $C:$C accordingly.
If day of the week/name will be without asterisk it also shall work correctly, name without one character works.
That's in separate place in attached file.