Counting cells

[Bob Flanagan]

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

 

[sherry]

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.