Re: How to total cells in a range with data input

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Peo Sjoblom (terre08_at_mvps.org)
Date: 05/08/04 

Date: Sat, 8 May 2004 11:24:25 -0400

Please refrain from multiposting, it's better to cross post one question for
multiple groups
than to post multiple same questions to multiple groups

=COUNT(B4:D14)

for numbers

=COUNTA(B4:D14)

for text and numbers 

-- 
Regards,
Peo Sjoblom
"SylviBeOS" <sdrsolo@openface.ca> wrote in message
news:uMtD79QNEHA.2644@TK2MSFTNGP11.phx.gbl...
> Greetings to all members
>
> I am running Excel 97.
>
> An office colleague presented me with an issue that might be of interest
to
> any Excel whiz and seasoned programmers.  I would certainly appreciate any
> pointers in solving it.  So here goes.
>
> The set of values includes 33 cells ranging from B4:D14.  The data type is
> numeric.  Data is only input in a few cells.
>
> QUESTION
>
> What would be the function to enter in, say, cell A15 to indicate the
total
> number of cells in range B4:D14 that have received data input?  Or does it
> involve some behind the scene VBA programming?
>
> EXAMPLE
>
> B6 = 9  C9 = 4  D11 = 0
> Consequently, cell A15 should total 3, as only 3 cells have received data
> input.  I hope I am making myself clear.  If not, please state so.
>
> Thanks a million for any assistance.
>
> Sylvie in Montreal
>
>

Relevant Pages

  • how do I change the colour of highlighted cells - too faint
    ... When I highlight a group of cells, or do multiple groups of cells, the colour ... is very faint and I cannot see if all of the correct cells have been ...
    (microsoft.public.excel.setup)
  • Re: HOW DO I SET UP REPEATING DATES IN EXCEL?
    ... See response to your other post. ... multiple groups. ... >consecutively and then skip the next four days and run in a continual pattern ... i want the first four cells to read ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Changing Security
    ... The section you need to look at is "Enable Mixed Mode Authentication After ... Please do not cross post to multiple groups. ... Mandar Naik ...
    (microsoft.public.sqlserver.security)
  • Re: Simple Query Question
    ... You posted this question in the Queries newsgroup at 4:13 PM PST. ... with that thread, rather than cross post. ... It's okay to multipost, when appropriate, but cross posting should be ... (separate posts of the same content to multiple groups) ...
    (microsoft.public.access.gettingstarted)
  • RE: Need Help with Creating a Database
    ... cross post by selecting multiple groups at the same time. ... current inventory of boxes and other moving supplies. ... Customer table ...
    (microsoft.public.access.gettingstarted)