RE: Help with a particular SUM formula

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

From: JT (JT_at_discussions.microsoft.com)
Date: 08/20/04 

Date: Fri, 20 Aug 2004 05:27:01 -0700

Hello all,

I've recreated both formulas and I'm just trying to figure out how and why
Frank's formula works. What returns the zero if c1=X? I'm guessing it has to
do with the true/false component. This is one great forum!
Thanks.

John

"David" wrote:

> Formula in cell AH37: =IF(C1="X",0,SUM(C37:AG37))
>
> Hope that helps
>
> David
>
> >-----Original Message-----
> >Gentlemen:
> >
> >Here is the problem: =SUM(C37:AG37,IF(C1="X",(AH37=0)))
> >
> >What I'd like to do is make the value in cell AH37 zero 0
> if the cell C1 has
> >an "X" in it. If C1 does not have an "X", display the
> actual value result of
> >the SUM function.
> >
> >Any assistance in this matter will be greatly appreciated.
> >
> >Thanks,
> >.
> >
>

Relevant Pages

  • Re: Zero & Infinity : A try to define them more exactly
    ... Before trying to come up with your own definition of zero (hint: ... Free will is truth. ... case they were a matter of life ... mathematics. ...
    (sci.math)
  • Re: .999... ?= 1
    ... consists of dicrete values and vice versa no matter ... for crossing the border between finite and infinite. ... So called counterintuitive strangeness is not strange to me at all. ... Also I was told that zero is not necessarily a number, ...
    (sci.math)
  • Re: Track bike.
    ... > matter for track use. ... market suspension isn't that common for a TRX, ... Loads of race bikes seem to be advertised sans V5 - I'm guessing mostly ... cat B write offs, registration 'lost', and never before registered (as ...
    (uk.rec.motorcycles)
  • Re: The Big Bang & Variable Light Speed
    ... It's not a matter of whether each of those statements ... distance, ... Proper time and proper distance are both invariant. ... BOTH are zero - since light follows a null path. ...
    (sci.physics.relativity)
  • Re: Natural selection and favorable traits how were they measured ?
    ... Sachs individual is zero no matter what *current* environment that ... sensitive bacteria is zero in an environment containing high enough ... So don't have-a-cow when your prodding elicits the same, drab responses. ...
    (talk.origins)