COUNTIF?
Hi Malcom,
Am Fri, 18 Sep 2015 16:13:12 +0100 schrieb Malcolm Austin:
=COUNTIF(C12,I12,O12,U12,AM12,AS12,AY12,BE12,BK12, BQ12,"X")
if there are only x in these columns you can use the formula from Garry.
If there are also x in the other columns the should not be count then
try:
=SUMPRODUCT(--(MOD(COLUMN(C12:BQ12),6)=3),--(C12:BQ12="x"))
Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional
|