Hi, I am trying to create an array formula that does the following:
Counts the number of times "Expression of wish" appears in 1 column and then "p" or "f" appears in another.
So if I get Expression of wish appearing and P it will count it
If in another row Expression of wish appears and F appears it will also count it
This is as far as I have got, can anybody help?
=SUM((January!B2:B3="expression of wish")*(January!F2:F3="p"))
Counts the number of times "Expression of wish" appears in 1 column and then "p" or "f" appears in another.
So if I get Expression of wish appearing and P it will count it
If in another row Expression of wish appears and F appears it will also count it
This is as far as I have got, can anybody help?
=SUM((January!B2:B3="expression of wish")*(January!F2:F3="p"))