Re: Count/Sum data with date entries.


If I go back to my original posting & question, I'm trying to go down 3
columns and depending on the sequence of dates entered, the formula
will return a "1" or "0".

Your formula works when associated to each row going down the columns.
I'm trying to have a formula in a single cell do the date validation
above, then sum/count the total "1" and this would be the result.

thx,
ken


--
KBW
------------------------------------------------------------------------
KBW's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=32730
View this thread: http://www.excelforum.com/showthread.php?threadid=525663

.

Relevant Pages

  • Re: PHP mt_srand no longer seeds same number!!!!! aaarrrg
    ... Your problem is you are depending on the ability to repeat a sequence. ... If you need to be able to repeat the sequence, I would suggest you write your own pseudo-random number generator. ...
    (comp.lang.php)
  • Re: J4 - presentation/discussion on "Future of the COBOL Standard"
    ... I believe that OCCURS DEPENDING ON is useful for tables that can have ... a variable number of entries and are in sequence for searching using ... I suspect the savings you might think is there is illusory. ...
    (comp.lang.cobol)
  • Re: Dating with DNA? Problems and Current Approaches
    ... Adcock et al did a sequence of LM3 and claimed it was as divergent from humans as Neandertals. ... The core eastern/east african mtDNA sequence is present in LM3 sequence but many other substitutions are present. ... published it did nothing more than assume a rate of mutation. ... We so commonly use the word generation but there are several different lengths for it depending upon the context in which it is used. ...
    (sci.archaeology)
  • Re: Design qq
    ... kaldrenon wrote: ... in sequence, it doesn't really matter, and depending on the size of ...
    (comp.lang.java.help)