Help please on how to add a new formula to an existing one

New Contributor

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

@Tracey59a 

=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.