| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Counting contents in aray
Thanks for reading this post.
One in each cell, there are several alphabets in a range of cells (eg. A1 :C10). I would like to know the combined count of alphabets "A" and "L". How can I achieve this? Tks Preman |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Counting contents in aray
=SUM(COUNTIF(A1:C10,{"A","L"}))
-- __________________________________ HTH Bob "jpreman" wrote in message ... Thanks for reading this post. One in each cell, there are several alphabets in a range of cells (eg. A1 :C10). I would like to know the combined count of alphabets "A" and "L". How can I achieve this? Tks Preman |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Counting contents in aray
=COUNTIF(A1:C10,"A")+COUNTIF(A1:C10,"L")
-- Gary''s Student - gsnu200807 "jpreman" wrote: Thanks for reading this post. One in each cell, there are several alphabets in a range of cells (eg. A1 :C10). I would like to know the combined count of alphabets "A" and "L". How can I achieve this? Tks Preman |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Counting contents in aray
Thanks Bob,
You have taught me a different (better) solution than the one I figured out within minutes of posting my question. Kind regards Preman "Bob Phillips" wrote: =SUM(COUNTIF(A1:C10,{"A","L"})) -- __________________________________ HTH Bob "jpreman" wrote in message ... Thanks for reading this post. One in each cell, there are several alphabets in a range of cells (eg. A1 :C10). I would like to know the combined count of alphabets "A" and "L". How can I achieve this? Tks Preman |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Counting contents in aray
Hi
Thanks for responding to my post. That's exactly what I was looking for. Kind regards Preman "Gary''s Student" wrote: =COUNTIF(A1:C10,"A")+COUNTIF(A1:C10,"L") -- Gary''s Student - gsnu200807 "jpreman" wrote: Thanks for reading this post. One in each cell, there are several alphabets in a range of cells (eg. A1 :C10). I would like to know the combined count of alphabets "A" and "L". How can I achieve this? Tks Preman |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Counting contents in aray
Hi Bob,
I would be thankful if you kindly explain how curly brackets work in formulas. Thanks & regards Preman "Bob Phillips" wrote: =SUM(COUNTIF(A1:C10,{"A","L"})) -- __________________________________ HTH Bob "jpreman" wrote in message ... Thanks for reading this post. One in each cell, there are several alphabets in a range of cells (eg. A1 :C10). I would like to know the combined count of alphabets "A" and "L". How can I achieve this? Tks Preman |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Counting contents in aray
Hi Preman,
The curly brackets signify an array constant, an array of values that will be used within the formula. For instance, COUNTIF normally checks a range against a particular value. If you use an array constant rather than a particular value, COUNTIF will return an array of values equivalent to multiple COUNTIF calls. The SUM is needed to sum this array returned by the COUNTIF. -- __________________________________ HTH Bob "jpreman" wrote in message ... Hi Bob, I would be thankful if you kindly explain how curly brackets work in formulas. Thanks & regards Preman "Bob Phillips" wrote: =SUM(COUNTIF(A1:C10,{"A","L"})) -- __________________________________ HTH Bob "jpreman" wrote in message ... Thanks for reading this post. One in each cell, there are several alphabets in a range of cells (eg. A1 :C10). I would like to know the combined count of alphabets "A" and "L". How can I achieve this? Tks Preman |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Counting contents in aray
That's great. Thanks a million Bob. Kind regards Preman "Bob Phillips" wrote: Hi Preman, The curly brackets signify an array constant, an array of values that will be used within the formula. For instance, COUNTIF normally checks a range against a particular value. If you use an array constant rather than a particular value, COUNTIF will return an array of values equivalent to multiple COUNTIF calls. The SUM is needed to sum this array returned by the COUNTIF. -- __________________________________ HTH Bob "jpreman" wrote in message ... Hi Bob, I would be thankful if you kindly explain how curly brackets work in formulas. Thanks & regards Preman "Bob Phillips" wrote: =SUM(COUNTIF(A1:C10,{"A","L"})) -- __________________________________ HTH Bob "jpreman" wrote in message ... Thanks for reading this post. One in each cell, there are several alphabets in a range of cells (eg. A1 :C10). I would like to know the combined count of alphabets "A" and "L". How can I achieve this? Tks Preman |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| VLOOKUP Question - Can I Keep the Same Aray with Drag? | Excel Worksheet Functions | |||
| Excel 2003 - Counting Contents of Cells | Excel Discussion (Misc queries) | |||
| Counting based on other cells contents... | Excel Discussion (Misc queries) | |||
| Complicated counting of cells (based on other cells contents) | Excel Worksheet Functions | |||
| Counting the Contents of Two Columns | Excel Discussion (Misc queries) | |||
Linear Mode
