Excel "COUNT" Formula Question

%3CLINGO-SUB%20id%3D%22lingo-sub-2065193%22%20slang%3D%22en-US%22%3EExcel%20%22COUNT%22%20Formula%20Question%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2065193%22%20slang%3D%22en-US%22%3E%3CP%3EI%20need%20one%20cell%20to%20count%20ONLY%20if%20ONE%20cell%20in%20a%20range%20of%20cells%20has%20a%20number.%20If%20they%20all%20remain%20blank%20or%20TWO%20cells%20have%20a%20number%20then%20it%20will%20not%20count%20them.%20I%20have%20tried%20COUNT%2C%20COUNTIF%20and%20COUNTA%2C%20and%20I%20cannot%20get%20it%20to%20work.%20If%20needed%2C%20details%20with%20cell%20numbers%20below...%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EC6%20is%20the%20cell%20I%20need%20to%20count.%3C%2FP%3E%3CP%3EThe%20range%20of%20cells%20is%20(D21%2CG21%2CI21%2CK21%2CN21%2CP21%2CS21%2CU21%2CX21%2CAA21%2CAD21%2CAF21%2CAH21%2CAJ21%2CAL21%2CAN21%2CAP21%2CAR21%2CAT21%2CAV21%2CAX21)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20help%20would%20be%20greatly%20appreciated!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2065193%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2065424%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20%22COUNT%22%20Formula%20Question%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2065424%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F930858%22%20target%3D%22_blank%22%3E%40cole1857%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ETry%20this%20formula%3A%3C%2FP%3E%3CP%3E%3DIF(COUNTA(D21%2CG21%2CI21%2CK21%2CN21%2CP21%2CS21%2CU21%2CX21%2CAA21%2CAD21%2CAF21%2CAH21%2CAJ21%2CAL21%2CAN21%2CAP21%2CAR21%2CAT21%2CAV21%2CAX21)%26lt%3B%3D2%2C0%2CCOUNTA(D21%2CG21%2CI21%2CK21%2CN21%2CP21%2CS21%2CU21%2CX21%2CAA21%2CAD21%2CAF21%2CAH21%2CAJ21%2CAL21%2CAN21%2CAP21%2CAR21%2CAT21%2CAV21%2CAX21))%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

I need one cell to count ONLY if ONE cell in a range of cells has a number. If they all remain blank or TWO cells have a number then it will not count them. I have tried COUNT, COUNTIF and COUNTA, and I cannot get it to work. If needed, details with cell numbers below...

 

C6 is the cell I need to count.

The range of cells is (D21,G21,I21,K21,N21,P21,S21,U21,X21,AA21,AD21,AF21,AH21,AJ21,AL21,AN21,AP21,AR21,AT21,AV21,AX21)

 

Any help would be greatly appreciated!

 

 

1 Reply

@cole1857 

 

Try this formula:

=IF(COUNTA(D21,G21,I21,K21,N21,P21,S21,U21,X21,AA21,AD21,AF21,AH21,AJ21,AL21,AN21,AP21,AR21,AT21,AV21,AX21)<=2,0,COUNTA(D21,G21,I21,K21,N21,P21,S21,U21,X21,AA21,AD21,AF21,AH21,AJ21,AL21,AN21,AP21,AR21,AT21,AV21,AX21))