G Gotroots Nov 6, 2009 #1 The following formula returns a total of 53 when in fact it should be 39 =COUNTA(AL10:AL8002)+'other additions'!AK5 puzzled
The following formula returns a total of 53 when in fact it should be 39 =COUNTA(AL10:AL8002)+'other additions'!AK5 puzzled
D Don Guillett Nov 6, 2009 #2 Perhaps the "dreaded space bar" has been touched =SUMPRODUCT((LEN(TRIM(M1:M21))>0)*1)
M Mike H Nov 6, 2009 #3 Hi, Not enough information but COUNTA will count all populated cells in the range. Mike
J Jacob Skaria Nov 6, 2009 #4 You must be having formulas in the range which return blank entries...Try one of these formulas =COUNTIF(AL10:AL8002,"?*")+COUNT(AL10:AL8002) =SUMPRODUCT(--(TRIM(AL10:AL8002)<>"")) If this post helps click Yes
You must be having formulas in the range which return blank entries...Try one of these formulas =COUNTIF(AL10:AL8002,"?*")+COUNT(AL10:AL8002) =SUMPRODUCT(--(TRIM(AL10:AL8002)<>"")) If this post helps click Yes
