Re: HELP with cum formula

Good point RD.........many times we post a response to an OP's question and
never hear from them again. The problem here in many cases is not to be
able to offer a correct Excel solution, but mostly to be able to figure out
from a cryptic query as to exactly what the OP really wants to know. When
we don't hear back, we don't know if the OP was happy with our offering, or
wasn't able to incorporate/understand it, or worse yet, we may have
misunderstood their problem and offered the wrong solution.....so they just
go away thinking they won't be able to do what they want to......bummer
there, for we're here to help. It's a good thing when the OP's heed your
suggestion and give closure to their original post.

Thanks for making the point.

Vaya con Dios,
Chuck, CABGx3




"Ragdyer" <RagDyer@xxxxxxxxxxxxx> wrote in message
news:uXczVQxnGHA.764@xxxxxxxxxxxxxxxxxxxxxxx
All of us here really appreciate it when you "get back" to us when it
*does*
work, as well as when it doesn't.
--
Regards,

RD

--------------------------------------------------------------------------
-
Please keep all correspondence within the NewsGroup, so all may benefit !
--------------------------------------------------------------------------
-
"Jannie" <Jannie@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:94542F5B-1B16-458B-91B3-AEEB9AF0B70F@xxxxxxxxxxxxxxxx
Thanks! I'm going to try this and see how it works. I appreciate
everyone's
help with this. This report is very important to us, so I hope this
works,
if not, I'll be back! :) Thanks everyone. - Jannie

"Ragdyer" wrote:

If I understand what you're asking for,
A *single* formula to return the number of the *latest*, consecutive,
non-productive days ( 0's ).

With your data in say Row1, from say A to AA,
Try this *array* formula:

=COUNT(A1:AA1)-MAX(IF(A1:AA1<>0,COLUMN(A1:AA1)))

--
Array formulas must be entered with CSE, <Ctrl> <Shift > <Enter>,
instead
of
the regular <Enter>, which will *automatically* enclose the formula in
curly
brackets, which *cannot* be done manually. Also, you must use CSE when
revising the formula.
--
HTH,

RD


-------------------------------------------------------------------------
--
Please keep all correspondence within the NewsGroup, so all may benefit
!

-------------------------------------------------------------------------
--
"Jannie" <Jannie@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:B1748FA8-B435-43A5-A64B-EDB38007F96A@xxxxxxxxxxxxxxxx
Example: I have a row of numbers - 0 0 0 0 5 0 0 0 2 0 0 0 0 0.
Each number is in a different column. Each number represents the
amount
of
gas (MCF) that flowed from a gaswell for that day. I want to count
the
number
of current days the gaswell has NOT been producing or is at (0). In
this
example the formula would begin counting - 4 days at zero, then the
well
produced 5 MCF so the formula goes back to 0. It starts again on day
six
counting 3 days of zero then sees there is 2 MCF so it goes back to
zero
and
starts over again. It sees on day 9 there is 2 MCF and goes back to
zero
again and starts over counting. The end result for this example is
the
well
currently has not produced for 5 days. If anyone can help with this
formula
I'd sure appreciate it! THANKS!!!!!





.

Relevant Pages

  • Re: HELP with cum formula
    ... > gas (MCF) that flowed from a gaswell for that day. ... > of current days the gaswell has NOT been producing or is at. ... > example the formula would begin counting - 4 days at zero, ...
    (microsoft.public.excel.misc)
  • Re: HELP with cum formula
    ... gas (MCF) that flowed from a gaswell for that day. ... of current days the gaswell has NOT been producing or is at. ... example the formula would begin counting - 4 days at zero, ...
    (microsoft.public.excel.misc)
  • Re: HELP with cum formula
    ... gas (MCF) that flowed from a gaswell for that day. ... of current days the gaswell has NOT been producing or is at. ... gaswell is not producing (i.e. is zero). ... example the formula would begin counting - 4 days at zero, ...
    (microsoft.public.excel.misc)
  • Re: D3/Linux compile question
    ... There is no element of anything that is number zero. ... By the way she did not break the plates that comes after ... And, I was not counting babies, I was ... depending upon the numbering convention. ...
    (comp.databases.pick)
  • Re: D3/Linux compile question
    ... timeline is zero, not one. ... Remember that we are counting discrete elements and there can be no ... the plates for a wedding. ... The numbering scheme of the array _has no impact_ on the size ...
    (comp.databases.pick)
Loading