Re: Count array cells that returned a result

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Ragdyer (RagDyer_at_cutoutmsn.com)
Date: 05/30/04 

Date: Sun, 30 May 2004 14:13:39 -0700

Another way to count the blanks, empties and/or formula nulls:

=COUNTIF(A1:D20,"") 

-- 
Regards,
RD
---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Peo Sjoblom" <terre08@mvps.org> wrote in message
news:OESDxXmREHA.3012@tk2msftngp13.phx.gbl...
> One way
>
> =COUNTBLANK(A1:D20)-SUMPRODUCT(--(ISBLANK(A1:D20)))
>
> will return the number of cells that have a "" produced by a formula
>
> -- 
>
>
> For everyone's benefit keep the discussion in the newsgroup.
>
> Regards,
>
> Peo Sjoblom
>
> "Dennis" <dmburgess@removespamameritech.net> wrote in message
> news:pv2kb0d3v53orvgn6427pkoge55ah22cd8@4ax.com...
> > Using 2003 at home and 2000 at work
> >
> > Would like to count the number of cells in a range that have a result
from
> a formula.
> >
> > The particular range of cells is filled with array formulae.
> >
> > Thus, the cells are not "" because they have a formula.
> >
> > But I would like to know how many cells, in the range of cells, where
the
> formula produced a
> > displayed value.
> >
> > I tried countif(A1:D20,not(""))     (and other variations without
success)
> >
> > TIA Dennis
>
>

Relevant Pages

  • Re: Average of the last n values in a column
    ... For everyone's benefit keep the discussion in the newsgroup. ... "Mike" wrote in message ... >>will average the last 5 non blank cells ... >>Peo Sjoblom ...
    (microsoft.public.excel.worksheet.functions)
  • Re: macros text dissappears
    ... "Charles Kenyon" wrote: ... You may have fixed-size cells and your text is still there but can't be ... See also the MVP FAQ: http://word.mvps.org/FAQs/ which is awesome! ... This message is posted to a newsgroup. ...
    (microsoft.public.word.docmanagement)
  • Re: Need help sizing table columns correctly
    ... Please reply to the newsgroup unless you wish to avail yourself of my ... I want to do this work via a macro in this ... you type" section in the With area, you will see a couple of table cells. ... .ApplyStyleHeadingRows = True ...
    (microsoft.public.word.vba.general)
  • Re: macros text dissappears
    ... Sounds even more like an online form. ... You may have fixed-size cells and your text is still there but can't be ... Microsoft's Legal Users' Guide) http://addbalance.com/usersguide ... This message is posted to a newsgroup. ...
    (microsoft.public.word.docmanagement)
  • Re: IF.........AND......THEN function?
    ... For everyone's benefit keep the discussion in the newsgroup. ... Peo Sjoblom ... > So basically I need excel to check the values in two cells and if they ... > logical test. ...
    (microsoft.public.excel.worksheet.functions)