t; SalesAid Software
>> dguille...@gmail.com
>>
>> *From:* jmothilal
>> *Sent:* Saturday, November 12, 2011 9:04 AM
>> *To:* excel-macros@googlegroups.com
>> *Subject:* Re: $$Excel-Macros$$ SUM Reg.
>>
>> Dear Excel members
>>
>> Thanks for m
A simple macro to clear the ranges
Range("D6:D25,F6:G25,J6:P25,T6:W25,Z6:Z25").ClearContents
Don Guillett
SalesAid Software
dguille...@gmail.com
From: jmothilal
Sent: Saturday, November 12, 2011 9:04 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ SUM Reg.
=SUMIF(D2:D21,"STOCK",G2:G21)
=SUMIF(D2:D21,"SALES",G2:G21)
On Sat, Nov 12, 2011 at 4:43 PM, Sam Mathai Chacko wrote:
> Here's a link
>
>
> http://windowssecrets.com/forums/showthread.php/109039-sumproduct-explained-with-double-unary-operator-%282003%29
>
> Do a search for Unary operators with
Here's a link
http://windowssecrets.com/forums/showthread.php/109039-sumproduct-explained-with-double-unary-operator-%282003%29
Do a search for Unary operators with Sumproduct, and you'll get quite a few
examples
Regards,
Sam
On Sat, Nov 12, 2011 at 4:41 PM, Sam Mathai Chacko wrote:
> -- or +
-- or ++ or a multiplication / division by 1, or a power by 1 etc are all
working as unary operators. So for example, a boolean value TRUE/FALSE can
be converted to either 1 or 0 respectively by using unary operators. And
since two minuses makes a positive, it is the same as multiplying with 1 or
d
plz tell me that what's the meaning of* -- *in fourmula
=SUMPRODUCT(*--*($D$2:$D$21=D22)*($E$2:$E$21))
On Sat, Nov 12, 2011 at 10:11 AM, jmothilal wrote:
> THANKS SO MUCH , ITS WORKING FINE GET THE RESULTS.
>
> THANKS WITH
>
> MOTHILAL.J
>
> On Fri, Nov 11, 2011 at 10:31 PM, NOORAIN ANSARI
THANKS SO MUCH , ITS WORKING FINE GET THE RESULTS.
THANKS WITH
MOTHILAL.J
On Fri, Nov 11, 2011 at 10:31 PM, NOORAIN ANSARI
wrote:
> Dear Mothilal,
>
> try this one..
> =SUMPRODUCT(--($D$2:$D$21=D22)*($E$2:$E$21))
> On Fri, Nov 11, 2011 at 8:23 PM, jmothilal wrote:
>
>> DEAR EXCEL MEMBERS ,
>>
Dear Mothilal,
try this one..
=SUMPRODUCT(--($D$2:$D$21=D22)*($E$2:$E$21))
On Fri, Nov 11, 2011 at 8:23 PM, jmothilal wrote:
> DEAR EXCEL MEMBERS ,
>
> I WANT TO SUM OF SPECIFIED ROWS , HERE WITH I ATTACHED FILES. I.E STOCK
> , SALES.
>
> THANKS WITH
>
>
>
> --
> J.Mohilal
> Universal Computer
Look in the help index for SUMIF
=SUMIF($D$2:$D$21,"stock",$G$2:$G$21)
Don Guillett
SalesAid Software
dguille...@gmail.com
From: jmothilal
Sent: Friday, November 11, 2011 8:53 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ SUM Reg.
DEAR EXCEL MEMBERS ,
I WANT
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ SUM Reg.
DEAR EXCEL MEMBERS ,
I WANT TO SUM OF SPECIFIED ROWS , HERE WITH I ATTACHED FILES. I.E STOCK ,
SALES.
THANKS WITH
--
J.Mohilal
Universal Computer Systems
# 16, Brindavan Complex
Otteri, Vellore-2
--
FORUM RULES (934
>
> *From:* jmothilal
> *Sent:* Friday, November 11, 2011 8:53 AM
> *To:* excel-macros@googlegroups.com
> *Subject:* $$Excel-Macros$$ SUM Reg.
>
> DEAR EXCEL MEMBERS ,
>
> I WANT TO SUM OF SPECIFIED ROWS , HERE WITH I ATTACHED FILES. I.E STOCK
> , SALES.
>
> THA
DEAR EXCEL MEMBERS ,
I WANT TO SUM OF SPECIFIED ROWS , HERE WITH I ATTACHED FILES. I.E STOCK ,
SALES.
THANKS WITH
--
J.Mohilal
Universal Computer Systems
# 16, Brindavan Complex
Otteri, Vellore-2
--
FORUM RULES (934+ members already BANNED for violation)
1) Use concise, accurate thread t
12 matches
Mail list logo
