Re: HELP with cum formula
- From: "CLR" <croberts@xxxxxxxxxxxxxxx>
- Date: Tue, 4 Jul 2006 20:16:28 -0400
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 messageinstead
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>,
--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
--
-------------------------------------------------------------------------
the"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
thenumber
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
well
currently has not produced for 5 days. If anyone can help with this
formula
I'd sure appreciate it! THANKS!!!!!
.
- References:
- Re: HELP with cum formula
- From: Ragdyer
- Re: HELP with cum formula
- From: Ragdyer
- Re: HELP with cum formula
- Prev by Date: Re: changing pictures according to cell value
- Next by Date: Re: executing a macro within another
- Previous by thread: Re: HELP with cum formula
- Next by thread: Re: HELP with cum formula
- Index(es):
Relevant Pages
|
