Forum Discussion

Copper Contributor

Sep 05, 2018

how to make a formulaL: count if a cell contains text and countif specific information from a table

I'm creating a schedule for work. HUGE project! I have a table "Levels" containing the following: LAST FIRST LEVEL Smith John 2 Jean Barbara ...

Silver Contributor

Sep 05, 2018

Hello Dylan

I get opposite results in the Wednesday column.

Select D7:J7, copy the formula into the formula bar and press CTRL-SHIFT-ENTER.

{=MMULT({1,1,1,1},("Level "&$B$2:$B$5=A12)*($D$2:$J$5<>""))}