Re: SUMIF() with AND() function??
From: Ron H (Ron.H.182tah_at_excelforum-nospam.com)
Date: 06/19/04
- Next message: shadestreet: "Re: What does the "--" mean when placed before a function/formula?"
- Previous message: Domenic: "Re: Help with Random Numbers"
- In reply to: Ann Scharpf: "SUMIF() with AND() function??"
- Next in thread: Ann Scharpf: "Re: SUMIF() with AND() function??"
- Reply: Ann Scharpf: "Re: SUMIF() with AND() function??"
- Messages sorted by: [ date ] [ thread ]
Date: Fri, 18 Jun 2004 21:29:07 -0500
You're referring to the unary operators.
Essentially the "double minus" coerces TRUE into -1 and then 1.
A FALSE remains 0.
Do a search for "unary" operators on the newsgroup.
There was one good discussion at
http://tinyurl.com/3d6tk
Ron Hekier
Ann Scharpf wrote:
> *Thanks, Peo, I will try that. I did look in the help
> under SUMPRODUCT() but I didn't get the impression that it
> would help me.
>
> I am assuming you mean the dashes to be in the formula.
> What do those mean?
>
> Thanks again.
>
> Ann
>
> >-----Original Message-----
> >One way
> >
> >=SUMPRODUCT(--(System="difms-c"),--
> (LaborType="maintenance"),Reg)
> >assuming you want to check the 2 first ranges for your
> criteria and when TRUE sum the 3rd. *
--- Message posted from http://www.ExcelForum.com/
- Next message: shadestreet: "Re: What does the "--" mean when placed before a function/formula?"
- Previous message: Domenic: "Re: Help with Random Numbers"
- In reply to: Ann Scharpf: "SUMIF() with AND() function??"
- Next in thread: Ann Scharpf: "Re: SUMIF() with AND() function??"
- Reply: Ann Scharpf: "Re: SUMIF() with AND() function??"
- Messages sorted by: [ date ] [ thread ]
