Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Counting cells
I wanted to count the number of cells in a range, where the range consisted
of multiple areas: A1:A10, B12, C:7:C14 Some cells have entries and some do not. Some entries are numbers and some are not. So, I tried =CountA(A1:A10, B12, C:7:C14) + CountBlank(A1:A10, B12, C:7:C14) However, CountBlank appears not to accept multiple areas!!! Is there an alternate equation that would work? If not, I can always write a user defined function, but would like to avoid doing so. Bob |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Counting cells
click on the cell where you want your final total to be. then click on the
little "sum" button on the toolbar. Now, click on the first range of numbers you want to add. Now, hold down "Ctrl" and continue; click ranges, individual cells, whatever you want to add; you'll see them all have the flashing dotted lines around them - keep doing this until you get to the end. Finally hit your "Enter" button and your total should be in that first cell where I told you click. -- sherry "Bob Flanagan" wrote: I wanted to count the number of cells in a range, where the range consisted of multiple areas: A1:A10, B12, C:7:C14 Some cells have entries and some do not. Some entries are numbers and some are not. So, I tried =CountA(A1:A10, B12, C:7:C14) + CountBlank(A1:A10, B12, C:7:C14) However, CountBlank appears not to accept multiple areas!!! Is there an alternate equation that would work? If not, I can always write a user defined function, but would like to avoid doing so. Bob |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Counting the number of cells between 2 seperate cells | Excel Discussion (Misc queries) | |||
counting cells that are 0 in a range of non-contiguous cells | Excel Worksheet Functions | |||
Query counting cells in a row that exactly match cells in another | Excel Discussion (Misc queries) | |||
Complicated counting of cells (based on other cells contents) | Excel Worksheet Functions | |||
Counting empty cells within a range of cells | New Users to Excel |