I've tried using this:=countif(B2:B200, <Open>)And it ends up looking like this:I want it to look like this:Or something similar to that. Basically I want to include the word Open and the number count of cells B2:B100Can someone please help?
How do I add a normal text with a Count fomula in the same cell?
google spreadsheets