Forum Discussion
Help please on how to add a new formula to an existing one
I have a formula =COUNTIF(G14:NG14,"AL")
and I want to be able to add an extra/new to the same range of cells.
How do I do this please??
2 Replies
=SUMPRODUCT((G14:NG14="AL")+(G14:NG14="DF"))Maybe with this formula if you want to count the occurences of AL and DF.
- Many thanks, I shall give this a go.
