I have a simple countif:= Countif(A1:A5,"statement")
. And I want it to count the statement n times if it appears n times in my cell A1 (plus of course the number of times it appears on the other cells).
How do I that? And How should it be written in the cell? Is it possible to use vectors and matrices? So that a cell can be written in the following way :=[statement 1,statement 2... etc].