In excel, the alphabets ",b,d,a,c,d,b,a,a" written in different columns. So whats the process to find out the total no. of a,b,c & d in a different cell. Pivot table doesn't work on this condition.
If there any formula to find out it?
Plz tell me as soon as possible, its very important......
2007-12-17 23:00:01 · 5 answers · asked by AKI_GREAT 1 in Computers & Internet ➔ Software
I want to show the no. of a,b,c & d individually.
2007-12-17 23:14:06 · update #1
assuming your data is in B2:F6,
to count the number of cells that contain the letter:
=COUNTIF(B2:F6,"*a*")
=COUNTIF(B2:F6,"*b*")
=COUNTIF(B2:F6,"*c*")
=COUNTIF(B2:F6,"*d*")
Good luck.
2007-12-25 19:28:06 · answer #1 · answered by MYs 5 · 0⤊ 0⤋
Where the letters are in cells A1 to F1 and you want to count the letter a. To count the other letters replace the "a" in the formula below with the letter you wish to count.
=COUNTIF(A1:F1,"a")
2007-12-17 23:18:23 · answer #2 · answered by HazMat 4 · 0⤊ 0⤋
if you are looking to find a count of a sequential range of values, say 'a' through 'c', then you should use an array formula
ie =sum ( (A1:C10>="a") * (A1:C10<="c") )
(note: array formulas are entered with CTRL+SHIFT+ENTER, not just ENTER)
if you are looking for individual letter counts, then use the countif function
2007-12-22 17:35:20 · answer #3 · answered by Anonymous · 0⤊ 0⤋
can you use the "Count" function?
ie Count a in a particular reigon of the spread sheet
2007-12-17 23:11:44 · answer #4 · answered by Anonymous · 0⤊ 0⤋
cell b2, =COUNTIF(A1:F1,"a")
cell c2, =COUNTIF(A1:F1,"b")
cell d2, =COUNTIF(A1:F1,"c")
cell e2, =COUNTIF(A1:F1,"d")
2007-12-18 04:31:23 · answer #5 · answered by clinky 3 · 0⤊ 0⤋