Apr 11 2022 01:01 AM
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??
Apr 11 2022 01:38 AM
=SUMPRODUCT((G14:NG14="AL")+(G14:NG14="DF"))
Maybe with this formula if you want to count the occurences of AL and DF.
Apr 11 2022 01:47 AM