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.
Dear Excel members
Thanks for more support, one more i need , i want erase the datas only not
formula is as usual in the cell . that mean clear the datas , next entry
Thanks with
Mothilal.J
On Sat, Nov 12, 2011 at 4:43 PM, Sam Mathai Chacko <samde...@gmail.com> 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 Sumproduct, and you'll get quite a few
examples
Regards,
Sam
On Sat, Nov 12, 2011 at 4:41 PM, Sam Mathai Chacko <samde...@gmail.com> wrote:
-- 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 dividing by 1
or powering by 1 ( as we know x^1 is x)
Unary operators can also be used to convert a numeric text in to a numeric
value
Regards
Sam Mathai Chacko
On Sat, Nov 12, 2011 at 11:02 AM, Sourabh Salgotra <rhtdmja...@gmail.com>
wrote:
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 <gjmothi...@gmail.com> 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
<noorain.ans...@gmail.com> 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 <gjmothi...@gmail.com>
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 Systems
# 16, Brindavan Complex
Otteri, Vellore-2
--
FORUM RULES (934+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like
Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
will not get quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any
security measure.
4) Acknowledge the responses you receive, good or bad.
5) Cross-promotion of, or links to, forums competitive to this
forum in signatures are prohibited.
NOTE : Don't ever post personal or confidential data in a workbook.
Forum owners and members are not responsible for any loss.
------------------------------------------------------------------------------------------------------
To post to this group, send email to excel-macros@googlegroups.com
--
Thanks & regards,
Noorain Ansari
http://excelmacroworld.blogspot.com/
http://noorain-ansari.blogspot.com/
--
FORUM RULES (934+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like
Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
will not get quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security
measure.
4) Acknowledge the responses you receive, good or bad.
5) Cross-promotion of, or links to, forums competitive to this forum
in signatures are prohibited.
NOTE : Don't ever post personal or confidential data in a workbook.
Forum owners and members are not responsible for any loss.
------------------------------------------------------------------------------------------------------
To post to this group, send email to excel-macros@googlegroups.com
--
J.Mohilal
Universal Computer Systems
# 16, Brindavan Complex
Otteri, Vellore-2
--
FORUM RULES (934+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please
Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will
not get quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security
measure.
4) Acknowledge the responses you receive, good or bad.
5) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited.
NOTE : Don't ever post personal or confidential data in a workbook.
Forum owners and members are not responsible for any loss.
------------------------------------------------------------------------------------------------------
To post to this group, send email to excel-macros@googlegroups.com
--
mujhay dukh is baat ka nahin kay meri zaat ko
muntashir karny walay haath tairy thy
mujhay dukh faqt is baat ka hay meri raiza raiza zaat ko
samaitnay walay haath tairy na thy
--------------------------------------------------------------------------------
Thanks & Regards
Sourabh
Contact Numbers: +91-94630-49202
Website:http://adhurapyaar.co.cc
--
FORUM RULES (934+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please
Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will
not get quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security
measure.
4) Acknowledge the responses you receive, good or bad.
5) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited.
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
------------------------------------------------------------------------------------------------------
To post to this group, send email to excel-macros@googlegroups.com
--
Sam Mathai Chacko
--
Sam Mathai Chacko
--
FORUM RULES (934+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited.
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
------------------------------------------------------------------------------------------------------
To post to this group, send email to excel-macros@googlegroups.com
--
J.Mothilal : Universal Computer Systems : # 16, Brindavan Complex :Otteri,
Vellore-2
--
FORUM RULES (934+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited.
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
------------------------------------------------------------------------------------------------------
To post to this group, send email to excel-macros@googlegroups.com
--
FORUM RULES (934+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited.
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
------------------------------------------------------------------------------------------------------
To post to this group, send email to excel-macros@googlegroups.com
