View Full Version : [SOLVED:] Count filled Cell where having number Only
r_know
09-03-2013, 05:07 AM
Dear All,
I have columns which contains as followings,
A1 20
A2 f
A3 01
A4 %
A5 .
A6 asgagshas
A7 2333
If I have to count "A" column , how much the numbers then they are total 03.
Can any one advise what could formula to count the filled cell with numbers?
Regards, RL
Hi, this can be used: =SUMPRODUCT(--ISNUMBER(-A1:A7))
r_know
09-03-2013, 06:21 AM
Thanks for your suggestion.
Also, meanwhile I try with count function and it also works in master file.
Good!
But please take into account that if cells are formatted as text then the suggested formula works anyway, but the COUNT function doesn't.
Try for example putting if A3 (refer to post#1) the text '01 or format that cell as text and put 01 to see the difference.
Best Regards
r_know
09-03-2013, 07:28 AM
I try as per the your suggestion; but in that case count function work perfectly rather to suggested formula.
Attach file10537
The COUNT returns 2, and surely it's the best choice if result meets your expectation.
Just for your info, my thoughts was as follows:
1. In post #1 the value of A1 is 01
Number with leading zero can be made by formatting A3 as text, or by manually applying "#00" format to the number value 1.
I was considering it's the text.
2. You wrote that result should be 3
If I have to count "A" column , how much the numbers then they are total 03
My understanding was the text 01 should be count as a number, and the suggested formula returns 3.
But hopefully it is not required :)
r_know
09-03-2013, 09:45 PM
Thanks For Explanation and my query solved!
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.