Re: $$Excel-Macros$$ Sumproduct Multiple Criteria formula

[amar takale]

Great Ankur SirExcellent😀😀

On Sun, Jun 24, 2018 at 12:02 AM, ankur  wrote:

> hi amar takale
>
> *Solution is attached as per your requirement ,i have not used sumproduct*
>
> *May this file help you*
>
>
>
>
>
> *With Regards:*
>
>  *CMA** Ankur Pandey*
>   *B.Com (H), C.M.A *
> *  Mob: :- +919532513513*
>
>
> *P* Please don't print this e-mail unless you really need it.
>
> "This e-mail message may contain confidential, proprietary or legally
> privileged information intended solely for the use of the addressee(s). If
> you are not the intended recipient, please notify the sender by e-mail and
> delete the original message. Further, you are not to copy, disclose, or
> distribute this e-mail or its contents either partly or completely. Before
> opening any attachments please check them for viruses and defects."
>
>
> On Sat, Apr 28, 2018 at 5:21 PM, amar takale  wrote:
>
>> This is Sample sheet
>>
>> On Sat, Apr 28, 2018 at 5:03 PM, amar takale 
>> wrote:
>>
>>>
>>> --
>>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?
>>> It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>>> https://www.facebook.com/discussexcel
>>>
>>> FORUM RULES
>>>
>>> 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) Jobs posting is not allowed.
>>> 6) Sharing copyrighted material and their links is not allowed.
>>>
>>> NOTE : Don't ever post confidential data in a workbook. Forum owners and
>>> members are not responsible for any loss.
>>> ---
>>> You received this message because you are subscribed to the Google
>>> Groups "MS EXCEL AND VBA MACROS" group.
>>> To unsubscribe from this group and stop receiving emails from it, send
>>> an email to excel-macros+unsubscr...@googlegroups.com.
>>> To post to this group, send email to excel-macros@googlegroups.com.
>>> Visit this group at https://groups.google.com/group/excel-macros.
>>> For more options, visit https://groups.google.com/d/optout.
>>>
>>
>> --
>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
>> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>> https://www.facebook.com/discussexcel
>>
>> FORUM RULES
>>
>> 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) Jobs posting is not allowed.
>> 6) Sharing copyrighted material and their links is not allowed.
>>
>> NOTE : Don't ever post confidential data in a workbook. Forum owners and
>> members are not responsible for any loss.
>> ---
>> You received this message because you are subscribed to the Google Groups
>> "MS EXCEL AND VBA MACROS" group.
>> To unsubscribe from this group and stop receiving emails from it, send an
>> email to excel-macros+unsubscr...@googlegroups.com.
>> To post to this group, send email to excel-macros@googlegroups.com.
>> Visit this group at https://groups.google.com/group/excel-macros.
>> For more options, visit https://groups.google.com/d/optout.
>>
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 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) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at https://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO

Re: $$Excel-Macros$$ SumProduct

[Waseem Saifi]

It converts values in Boolean (TRUE or FALSE, 1 or 0) which are enclosed in
bracket after "--".

On Tue, Sep 23, 2014 at 10:40 AM, SUDHIR VERMA  wrote:

> Dear Ravi,
> what is use of "--" before B2:B13 in above formula.
>
> Please explain.
>
>
>
> On 13 September 2013 16:28, Ravi Kumar  wrote:
>
>> Hi,
>>
>>
>>
>> Try this..
>>
>>
>>
>> =SUMPRODUCT((E1=A2:A13)*(--B2:B13=F1)*(C2:C13=G1)*(D2:D13))
>>
>>
>>
>>
>>
>>
>>
>> *Warm Regards,*
>>
>> *Ravi Kumar.*
>>
>>
>>
>> *From:* excel-macros@googlegroups.com [mailto:
>> excel-macros@googlegroups.com] *On Behalf Of *Chandra Shekar
>> *Sent:* Friday, September 13, 2013 4:21 PM
>> *To:* excel-macros@googlegroups.com
>> *Subject:* $$Excel-Macros$$ SumProduct
>>
>>
>>
>> Hi,
>>
>>
>>
>> I have a problem with Sumproduct function please find attached file for
>> the same where from E1, F1 & G1 are condtions based on it I need sum up
>> Column D.
>>
>>
>>
>> Thanks in advance.
>>
>>
>>
>> Regards,
>>
>>
>>
>> Chandra
>>
>>
>>
>>
>>
>> --
>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
>> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>> https://www.facebook.com/discussexcel
>>
>> FORUM RULES
>>
>> 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) Jobs posting is not allowed.
>> 6) Sharing copyrighted material and their links is not allowed.
>>
>> NOTE : Don't ever post confidential data in a workbook. Forum owners and
>> members are not responsible for any loss.
>> ---
>> You received this message because you are subscribed to the Google Groups
>> "MS EXCEL AND VBA MACROS" group.
>> To unsubscribe from this group and stop receiving emails from it, send an
>> email to excel-macros+unsubscr...@googlegroups.com.
>> To post to this group, send email to excel-macros@googlegroups.com.
>> Visit this group at http://groups.google.com/group/excel-macros.
>> For more options, visit https://groups.google.com/groups/opt_out.
>>
>> --
>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
>> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>> https://www.facebook.com/discussexcel
>>
>> FORUM RULES
>>
>> 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) Jobs posting is not allowed.
>> 6) Sharing copyrighted material and their links is not allowed.
>>
>> NOTE : Don't ever post confidential data in a workbook. Forum owners and
>> members are not responsible for any loss.
>> ---
>> You received this message because you are subscribed to the Google Groups
>> "MS EXCEL AND VBA MACROS" group.
>> To unsubscribe from this group and stop receiving emails from it, send an
>> email to excel-macros+unsubscr...@googlegroups.com.
>> To post to this group, send email to excel-macros@googlegroups.com.
>> Visit this group at http://groups.google.com/group/excel-macros.
>> For more options, visit https://groups.google.com/groups/opt_out.
>>
>
>  --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 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

Re: $$Excel-Macros$$ SumProduct

[SUDHIR VERMA]

Dear Ravi,
what is use of "--" before B2:B13 in above formula.

Please explain.



On 13 September 2013 16:28, Ravi Kumar  wrote:

> Hi,
>
>
>
> Try this..
>
>
>
> =SUMPRODUCT((E1=A2:A13)*(--B2:B13=F1)*(C2:C13=G1)*(D2:D13))
>
>
>
>
>
>
>
> *Warm Regards,*
>
> *Ravi Kumar.*
>
>
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Chandra Shekar
> *Sent:* Friday, September 13, 2013 4:21 PM
> *To:* excel-macros@googlegroups.com
> *Subject:* $$Excel-Macros$$ SumProduct
>
>
>
> Hi,
>
>
>
> I have a problem with Sumproduct function please find attached file for
> the same where from E1, F1 & G1 are condtions based on it I need sum up
> Column D.
>
>
>
> Thanks in advance.
>
>
>
> Regards,
>
>
>
> Chandra
>
>
>
>
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 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) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/groups/opt_out.
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 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) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/groups/opt_out.
>

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

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) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

Re: $$Excel-Macros$$ SUMPRODUCT: #VALUE ERROR

[DILIPandey]

Hi MLT,

Try using below formula which need to be confirmed using key combination:
ctrl shift enter

=IF(ISNUMBER(MATCH(A5,MID($A$1:$A$3,MIN(IFERROR(SEARCH($A$4,$A$1:$A$3),""))+2,1)*1,0)),"Matching","NotMatching")


Regards,
DILIPandey


On Tue, Jan 14, 2014 at 6:10 PM, MLT  wrote:

> I'm looking for some help with one of the components of a SUMPRODUCT
> formula that is causing the formula to error:
>
> Starting in A1:
>
> alpha137
> beta224
> gamma492
>
> in A4: 49
> in A5: 2
>
> The idea is for one of the components of the SUMPRODUCT formula to look
> for a string (in A4) in each cell in the range (A1:A3) and return the
> number character that follows the string to see if it's equal to a certain
> value (A5).
>
> The problem is that since "49" does not necessarily appear in all cells,
> it creates an error for all those, causing the entire formula to error.
>
> Any suggestions?
>
> =SUMPRODUCT((MID(A4,FIND("49",$A$1:$A$3)+2,1)=A5)*()*...*()
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 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) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/groups/opt_out.
>



-- 
Thanks & Regards,

DILIP KUMAR PANDEY,
mvp
   MBA,BCA,B.Com(Hons)
UAE +971 528225509 India +91 9810929744
dilipan...@gmail.com, dilipan...@yahoo.com

Skype: dilipandey | Gtalk: dilipandey | Yahoo: dilipandey

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

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) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.

$$Excel-Macros$$ SUMPRODUCT: #VALUE ERROR

[MLT]

I'm looking for some help with one of the components of a SUMPRODUCT 
formula that is causing the formula to error:
 
Starting in A1:
 
alpha137
beta224
gamma492
 
in A4: 49
in A5: 2
 
The idea is for one of the components of the SUMPRODUCT formula to look for 
a string (in A4) in each cell in the range (A1:A3) and return the number 
character that follows the string to see if it's equal to a certain value 
(A5).
 
The problem is that since "49" does not necessarily appear in all cells, it 
creates an error for all those, causing the entire formula to error.
 
Any suggestions?
 
=SUMPRODUCT((MID(A4,FIND("49",$A$1:$A$3)+2,1)=A5)*()*...*()

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

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) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.

RE: $$Excel-Macros$$ SumProduct

[Ravi Kumar]

Ur welcome

 

 

 

Warm Regards,

Ravi Kumar.

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Chandra Shekar
Sent: Monday, September 16, 2013 12:27 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ SumProduct

 

Hello,

 

Thanks its working fine..

On Fri, Sep 13, 2013 at 4:28 PM, Ravi Kumar mailto:excellearn2...@gmail.com> > wrote:

Hi,

 

Try this..

 

=SUMPRODUCT((E1=A2:A13)*(--B2:B13=F1)*(C2:C13=G1)*(D2:D13))

 

 

 

Warm Regards,

Ravi Kumar.

 

From: excel-macros@googlegroups.com <mailto:excel-macros@googlegroups.com>
[mailto:excel-macros@googlegroups.com <mailto:excel-macros@googlegroups.com>
] On Behalf Of Chandra Shekar
Sent: Friday, September 13, 2013 4:21 PM
To: excel-macros@googlegroups.com <mailto:excel-macros@googlegroups.com> 
Subject: $$Excel-Macros$$ SumProduct

 

Hi,

 

I have a problem with Sumproduct function please find attached file for the
same where from E1, F1 & G1 are condtions based on it I need sum up Column
D.

 

Thanks in advance.

 

Regards,

 

Chandra

 

 

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
 
FORUM RULES
 
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) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.
 
NOTE : Don't ever post confidential data in a workbook. Forum owners and
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups
"MS EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to excel-macros+unsubscr...@googlegroups.com
<mailto:excel-macros+unsubscr...@googlegroups.com> .
To post to this group, send email to excel-macros@googlegroups.com
<mailto:excel-macros@googlegroups.com> .
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
 
FORUM RULES
 
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) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.
 
NOTE : Don't ever post confidential data in a workbook. Forum owners and
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups
"MS EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to excel-macros+unsubscr...@googlegroups.com
<mailto:excel-macros%2bunsubscr...@googlegroups.com> .
To post to this group, send email to excel-macros@googlegroups.com
<mailto:excel-macros@googlegroups.com> .
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.

 

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
 
FORUM RULES
 
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) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.
 
NOTE : Don't ever post confidential data in a workbook. Forum owners and
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups
"MS EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to excel-macros+unsubscr...@googlegroups.com
<mailto:excel-macros+unsubscr...@googlegroups.com> .
To post to this 

Re: $$Excel-Macros$$ SumProduct

[Chandra Shekar]

Hello,

Thanks its working fine..

On Fri, Sep 13, 2013 at 4:28 PM, Ravi Kumar wrote:

>  Hi,
>
> ** **
>
> Try this..
>
> ** **
>
> =SUMPRODUCT((E1=A2:A13)*(--B2:B13=F1)*(C2:C13=G1)*(D2:D13))
>
> ** **
>
> ** **
>
> * *
>
> *Warm Regards,*
>
> *Ravi Kumar.*
>
> ** **
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Chandra Shekar
> *Sent:* Friday, September 13, 2013 4:21 PM
> *To:* excel-macros@googlegroups.com
> *Subject:* $$Excel-Macros$$ SumProduct
>
> ** **
>
> Hi,
>
>  
>
> I have a problem with Sumproduct function please find attached file for
> the same where from E1, F1 & G1 are condtions based on it I need sum up
> Column D.
>
>  
>
> Thanks in advance.
>
>  
>
> Regards,
>
>  
>
> Chandra
>
>  
>
>  
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 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) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/groups/opt_out.
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 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) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/groups/opt_out.
>

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

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) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.

RE: $$Excel-Macros$$ SumProduct

[Ravi Kumar]

Hi,

 

Try this..

 

=SUMPRODUCT((E1=A2:A13)*(--B2:B13=F1)*(C2:C13=G1)*(D2:D13))

 

 

 

Warm Regards,

Ravi Kumar.

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Chandra Shekar
Sent: Friday, September 13, 2013 4:21 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ SumProduct

 

Hi,

 

I have a problem with Sumproduct function please find attached file for the
same where from E1, F1 & G1 are condtions based on it I need sum up Column
D.

 

Thanks in advance.

 

Regards,

 

Chandra

 

 

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
 
FORUM RULES
 
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) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.
 
NOTE : Don't ever post confidential data in a workbook. Forum owners and
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups
"MS EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to excel-macros+unsubscr...@googlegroups.com
<mailto:excel-macros+unsubscr...@googlegroups.com> .
To post to this group, send email to excel-macros@googlegroups.com
<mailto:excel-macros@googlegroups.com> .
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

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) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.

$$Excel-Macros$$ SumProduct

[Chandra Shekar]

Hi,

I have a problem with Sumproduct function please find attached file for the
same where from E1, F1 & G1 are condtions based on it I need sum up Column
D.

Thanks in advance.

Regards,

Chandra

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

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) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.


Sumproduct.xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ Sumproduct using VBA

[vba]

hi

To insert sumproduct formula thru VBA you by using evaluate.

Pl refer http://www.xldynamic.com/source/xld.SUMPRODUCT.html

HTH//Cheers


On Fri, Jul 12, 2013 at 7:17 PM, Chandra Shekar <
chandrashekarb@gmail.com> wrote:

> Hi,
>
> Could you please let me know how to use sumproduct using VBA? Where range
> is date values.
>
>
> =SUMPRODUCT(--(INT(Dump!$F$2:$F$5)>=C2)*(INT(Dump!$F$2:$F$5)<=D2)*--((Dump!$D$2:$D$5="U")+(Dump!$D$2:$D$5="E")>0))
>
>
> Regards
>
> Chandra
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 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) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/groups/opt_out.
>
>
>

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

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) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.

Re: $$Excel-Macros$$ Sumproduct using VBA

[Chandra Shekar]

Hi,

Could you please let me know what your are asking for?

Thanks in advance.

Regards,

Chandra

On Sat, Jul 13, 2013 at 7:23 AM, Bé Trần Văn wrote:

> With VBA require you to download the file
>
>  2013/7/12 Chandra Shekar 
>
>> Hi,
>>
>> Could you please let me know how to use sumproduct using VBA? Where range
>> is date values.
>>
>>
>> =SUMPRODUCT(--(INT(Dump!$F$2:$F$5)>=C2)*(INT(Dump!$F$2:$F$5)<=D2)*--((Dump!$D$2:$D$5="U")+(Dump!$D$2:$D$5="E")>0))
>>
>>
>> Regards
>>
>> Chandra
>>
>> --
>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
>> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>> https://www.facebook.com/discussexcel
>>
>> FORUM RULES
>>
>> 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) Jobs posting is not allowed.
>> 6) Sharing copyrighted material and their links is not allowed.
>>
>> NOTE : Don't ever post confidential data in a workbook. Forum owners and
>> members are not responsible for any loss.
>> ---
>> You received this message because you are subscribed to the Google Groups
>> "MS EXCEL AND VBA MACROS" group.
>> To unsubscribe from this group and stop receiving emails from it, send an
>> email to excel-macros+unsubscr...@googlegroups.com.
>> To post to this group, send email to excel-macros@googlegroups.com.
>> Visit this group at http://groups.google.com/group/excel-macros.
>> For more options, visit https://groups.google.com/groups/opt_out.
>>
>>
>>
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 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) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/groups/opt_out.
>
>
>

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

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) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.

Re: $$Excel-Macros$$ Sumproduct using VBA

[Bé Trần Văn]

With VBA require you to download the file

2013/7/12 Chandra Shekar 

> Hi,
>
> Could you please let me know how to use sumproduct using VBA? Where range
> is date values.
>
>
> =SUMPRODUCT(--(INT(Dump!$F$2:$F$5)>=C2)*(INT(Dump!$F$2:$F$5)<=D2)*--((Dump!$D$2:$D$5="U")+(Dump!$D$2:$D$5="E")>0))
>
>
> Regards
>
> Chandra
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 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) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/groups/opt_out.
>
>
>

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

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) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.

$$Excel-Macros$$ Sumproduct using VBA

[Chandra Shekar]

Hi,

Could you please let me know how to use sumproduct using VBA? Where range
is date values.

=SUMPRODUCT(--(INT(Dump!$F$2:$F$5)>=C2)*(INT(Dump!$F$2:$F$5)<=D2)*--((Dump!$D$2:$D$5="U")+(Dump!$D$2:$D$5="E")>0))


Regards

Chandra

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

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) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.

Re: $$Excel-Macros$$ Sumproduct help

[Chandra Shekar]

Hi All,

Thanks its working fine.

Regards,

Chandra

On Tue, Jul 2, 2013 at 8:51 PM, De Premor  wrote:

> Try using SUM with CSE
>
> =SUM((C2:C11>C3)+((C2:C11>C3)*(B2:B11="A")))
>
> Or SUMPRODUCT
> =SUMPRODUCT((C2:C11>C3)+((C2:C11>C3)*(B2:B11="A")))
>
> Rgds,
> [dp]
>
> Pada 02/07/2013 20:51, Chandra Shekar menulis:
>
> Hi,
>
> Could you please help me in the attached file instruction is there in it.
>
> Thanks in advance.
>
> Regards,
>
> Chandra
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 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) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/groups/opt_out.
>
>
>
>
>  --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 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) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/groups/opt_out.
>
>
>

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

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) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.

Re: $$Excel-Macros$$ Sumproduct help

[De Premor]

Try using SUM with CSE

=SUM((C2:C11>C3)+((C2:C11>C3)*(B2:B11="A")))

Or SUMPRODUCT
=SUMPRODUCT((C2:C11>C3)+((C2:C11>C3)*(B2:B11="A")))

Rgds,
[dp]

Pada 02/07/2013 20:51, Chandra Shekar menulis:

Hi,
Could you please help me in the attached file instruction is there in it.
Thanks in advance.
Regards,
Chandra
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? 
It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel


FORUM RULES

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) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE : Don't ever post confidential data in a workbook. Forum owners 
and members are not responsible for any loss.

---
You received this message because you are subscribed to the Google 
Groups "MS EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send 
an email to excel-macros+unsubscr...@googlegroups.com.

To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.




--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

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) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group.

To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.

Re: $$Excel-Macros$$ Sumproduct help

[priti verma]

=SUMPRODUCT(N(DATE(YEAR(C2:C11),MONTH(C2:C11),DAY(C2:C11))>=DATE(2013,8,2)),N($B$2:$B$11="A"))
with CSE


On Tue, Jul 2, 2013 at 7:27 AM, Chandra Shekar  wrote:

> Hi,
>
> Am getting a wrong count as 2 I have changed the E5 with date.
>
> Regard,
>
> Chandra
>
> On Tue, Jul 2, 2013 at 7:30 PM, priti verma wrote:
>
>> =SUMPRODUCT(N($C$2:$C$11>=E5),N($B$2:$B$11="A")) with cse
>>
>>
>> On Tue, Jul 2, 2013 at 6:51 AM, Chandra Shekar <
>> chandrashekarb@gmail.com> wrote:
>>
>>> Hi,
>>>
>>> Could you please help me in the attached file instruction is there in it.
>>>
>>> Thanks in advance.
>>>
>>> Regards,
>>>
>>> Chandra
>>>
>>> --
>>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?
>>> It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>>> https://www.facebook.com/discussexcel
>>>
>>> FORUM RULES
>>>
>>> 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) Jobs posting is not allowed.
>>> 6) Sharing copyrighted material and their links is not allowed.
>>>
>>> NOTE : Don't ever post confidential data in a workbook. Forum owners and
>>> members are not responsible for any loss.
>>> ---
>>> You received this message because you are subscribed to the Google
>>> Groups "MS EXCEL AND VBA MACROS" group.
>>> To unsubscribe from this group and stop receiving emails from it, send
>>> an email to excel-macros+unsubscr...@googlegroups.com.
>>> To post to this group, send email to excel-macros@googlegroups.com.
>>> Visit this group at http://groups.google.com/group/excel-macros.
>>> For more options, visit https://groups.google.com/groups/opt_out.
>>>
>>>
>>>
>>
>> --
>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
>> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>> https://www.facebook.com/discussexcel
>>
>> FORUM RULES
>>
>> 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) Jobs posting is not allowed.
>> 6) Sharing copyrighted material and their links is not allowed.
>>
>> NOTE : Don't ever post confidential data in a workbook. Forum owners and
>> members are not responsible for any loss.
>> ---
>> You received this message because you are subscribed to the Google Groups
>> "MS EXCEL AND VBA MACROS" group.
>> To unsubscribe from this group and stop receiving emails from it, send an
>> email to excel-macros+unsubscr...@googlegroups.com.
>> To post to this group, send email to excel-macros@googlegroups.com.
>> Visit this group at http://groups.google.com/group/excel-macros.
>> For more options, visit https://groups.google.com/groups/opt_out.
>>
>>
>>
>
>  --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 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) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/groups/opt_out.
>
>
>

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

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 

Re: $$Excel-Macros$$ Sumproduct help

[Chandra Shekar]

Hi,

Am getting a wrong count as 2 I have changed the E5 with date.

Regard,

Chandra

On Tue, Jul 2, 2013 at 7:30 PM, priti verma wrote:

> =SUMPRODUCT(N($C$2:$C$11>=E5),N($B$2:$B$11="A")) with cse
>
>
> On Tue, Jul 2, 2013 at 6:51 AM, Chandra Shekar <
> chandrashekarb@gmail.com> wrote:
>
>> Hi,
>>
>> Could you please help me in the attached file instruction is there in it.
>>
>> Thanks in advance.
>>
>> Regards,
>>
>> Chandra
>>
>> --
>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
>> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>> https://www.facebook.com/discussexcel
>>
>> FORUM RULES
>>
>> 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) Jobs posting is not allowed.
>> 6) Sharing copyrighted material and their links is not allowed.
>>
>> NOTE : Don't ever post confidential data in a workbook. Forum owners and
>> members are not responsible for any loss.
>> ---
>> You received this message because you are subscribed to the Google Groups
>> "MS EXCEL AND VBA MACROS" group.
>> To unsubscribe from this group and stop receiving emails from it, send an
>> email to excel-macros+unsubscr...@googlegroups.com.
>> To post to this group, send email to excel-macros@googlegroups.com.
>> Visit this group at http://groups.google.com/group/excel-macros.
>> For more options, visit https://groups.google.com/groups/opt_out.
>>
>>
>>
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 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) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/groups/opt_out.
>
>
>

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

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) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.

Re: $$Excel-Macros$$ Sumproduct help

[priti verma]

=SUMPRODUCT(N($C$2:$C$11>=E5),N($B$2:$B$11="A")) with cse


On Tue, Jul 2, 2013 at 6:51 AM, Chandra Shekar  wrote:

> Hi,
>
> Could you please help me in the attached file instruction is there in it.
>
> Thanks in advance.
>
> Regards,
>
> Chandra
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 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) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/groups/opt_out.
>
>
>

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

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) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.

$$Excel-Macros$$ Sumproduct help

[Chandra Shekar]

Hi,

Could you please help me in the attached file instruction is there in it.

Thanks in advance.

Regards,

Chandra

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

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) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.




Sumproduct.xls
Description: MS-Excel spreadsheet

$$Excel-Macros$$ Sumproduct Formula -Min-Function-Error

[prafull jadhav]

Dear All,

Sumproduct function return the Max function output but Not a Min fuction
Output .

for example

I got output when i use max function but when i try to get output for min
value out put is Zero.


 =SUMPRODUCT(MAX(($E$6:$E$20=E6)*($F$6:$F$20)))  E column is Region and F
column is Amount

Regards,
Prafull Jadhav.
MIS-Executive.

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

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) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.

Re: $$Excel-Macros$$ Sumproduct Formula Required

[ashish koul]

 edit the formula in cells D163 and below and add =IFERROR(AX8/V8,0) . add
If error in all to avoid value errors

Or try this
=SUM(IF(ISNUMBER($C$163:$C$182+$D$163:$D$182),$C$163:$C$182*$D$163:$D$182,0))/C183
 with Ctrl+shift+ Enter

or
Visit this link
http://www.mrexcel.com/forum/excel-questions/289317-sumproduct-ignore-errors.html






On Fri, Jan 11, 2013 at 2:33 PM, Aindril De  wrote:

> If you Delete the rows mentioned.. then the formula you have mentioned
> works
>
>
> On Fri, Jan 11, 2013 at 2:09 PM, amar takale  wrote:
>
>> No problem hide row delete,no matter.
>>
>>
>> On Fri, Jan 11, 2013 at 1:59 PM, Aindril De  wrote:
>>
>>> Dear Amar,
>>>
>>> You are getting a #Value error.. since you have the following #Value
>>> errors in your data.
>>>
>>>
>>>   ASTRAZENECA PHARMA INDIA LTD 36 #VALUE!  PFIZER LIMITED 35 17.6  SUN
>>> PHARMA ADVANCED RESEARCH 33 #VALUE!
>>>
>>> On Fri, Jan 11, 2013 at 12:15 PM, amar takale wrote:
>>>
 Hi All,
 Pls suggest me Sumproduct formula in Row 185. I Put formula Row 183 but
 it is so long & Confusing.Pls suggest me simple formula for solution

 Regards
 Amar

 --
 Join official Facebook page of this forum @
 https://www.facebook.com/discussexcel

 FORUM RULES

 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) Jobs posting is not allowed.
 6) Sharing copyrighted material and their links is not allowed.

 NOTE : Don't ever post confidential data in a workbook. Forum owners
 and members are not responsible for any loss.
 ---
 You received this message because you are subscribed to the Google
 Groups "MS EXCEL AND VBA MACROS" group.
 To post to this group, send email to excel-macros@googlegroups.com.
 To unsubscribe from this group, send email to
 excel-macros+unsubscr...@googlegroups.com.
 Visit this group at http://groups.google.com/group/excel-macros?hl=en.



>>>
>>>
>>>
>>> --
>>>
>>> Warm Regards,
>>> Aindril De
>>> Ph: 9811300157
>>>
>>> --
>>> Join official Facebook page of this forum @
>>> https://www.facebook.com/discussexcel
>>>
>>> FORUM RULES
>>>
>>> 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) Jobs posting is not allowed.
>>> 6) Sharing copyrighted material and their links is not allowed.
>>>
>>> NOTE : Don't ever post confidential data in a workbook. Forum owners and
>>> members are not responsible for any loss.
>>> ---
>>> You received this message because you are subscribed to the Google
>>> Groups "MS EXCEL AND VBA MACROS" group.
>>> To post to this group, send email to excel-macros@googlegroups.com.
>>> To unsubscribe from this group, send email to
>>> excel-macros+unsubscr...@googlegroups.com.
>>> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
>>>
>>>
>>>
>>
>>  --
>> Join official Facebook page of this forum @
>> https://www.facebook.com/discussexcel
>>
>> FORUM RULES
>>
>> 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) Jobs posting is not allowed.
>> 6) Sharing copyrighted material and their links is not allowed.
>>
>> NOTE : Don't ever post confidential data in a workbook. Forum owners and
>> members are not responsible for any loss.
>> ---
>> You received this message because you are subscribed to the Google Groups
>> "MS EXCEL AND VBA MACROS" group.
>> To post to this group, send email to excel-macros@googlegroups.com.
>> To unsubscribe from this group, send email to
>> excel-macros+unsubscr...@googlegroups.com.
>> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
>>
>>
>>
>
>
>
> --
>
> Warm Regards,
> Aindril De
> Ph: 9811300157
>
> --
> Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 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

Re: $$Excel-Macros$$ Sumproduct Formula Required

[Aindril De]

If you Delete the rows mentioned.. then the formula you have mentioned works

On Fri, Jan 11, 2013 at 2:09 PM, amar takale  wrote:

> No problem hide row delete,no matter.
>
>
> On Fri, Jan 11, 2013 at 1:59 PM, Aindril De  wrote:
>
>> Dear Amar,
>>
>> You are getting a #Value error.. since you have the following #Value
>> errors in your data.
>>
>>
>>   ASTRAZENECA PHARMA INDIA LTD 36 #VALUE!  PFIZER LIMITED 35 17.6  SUN
>> PHARMA ADVANCED RESEARCH 33 #VALUE!
>>
>> On Fri, Jan 11, 2013 at 12:15 PM, amar takale wrote:
>>
>>> Hi All,
>>> Pls suggest me Sumproduct formula in Row 185. I Put formula Row 183 but
>>> it is so long & Confusing.Pls suggest me simple formula for solution
>>>
>>> Regards
>>> Amar
>>>
>>> --
>>> Join official Facebook page of this forum @
>>> https://www.facebook.com/discussexcel
>>>
>>> FORUM RULES
>>>
>>> 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) Jobs posting is not allowed.
>>> 6) Sharing copyrighted material and their links is not allowed.
>>>
>>> NOTE : Don't ever post confidential data in a workbook. Forum owners and
>>> members are not responsible for any loss.
>>> ---
>>> You received this message because you are subscribed to the Google
>>> Groups "MS EXCEL AND VBA MACROS" group.
>>> To post to this group, send email to excel-macros@googlegroups.com.
>>> To unsubscribe from this group, send email to
>>> excel-macros+unsubscr...@googlegroups.com.
>>> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
>>>
>>>
>>>
>>
>>
>>
>> --
>>
>> Warm Regards,
>> Aindril De
>> Ph: 9811300157
>>
>> --
>> Join official Facebook page of this forum @
>> https://www.facebook.com/discussexcel
>>
>> FORUM RULES
>>
>> 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) Jobs posting is not allowed.
>> 6) Sharing copyrighted material and their links is not allowed.
>>
>> NOTE : Don't ever post confidential data in a workbook. Forum owners and
>> members are not responsible for any loss.
>> ---
>> You received this message because you are subscribed to the Google Groups
>> "MS EXCEL AND VBA MACROS" group.
>> To post to this group, send email to excel-macros@googlegroups.com.
>> To unsubscribe from this group, send email to
>> excel-macros+unsubscr...@googlegroups.com.
>> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
>>
>>
>>
>
>  --
> Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 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) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To post to this group, send email to excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
>
>
>



-- 

Warm Regards,
Aindril De
Ph: 9811300157

-- 
Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

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) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA M

Re: $$Excel-Macros$$ Sumproduct Formula Required

[amar takale]

No problem hide row delete,no matter.

On Fri, Jan 11, 2013 at 1:59 PM, Aindril De  wrote:

> Dear Amar,
>
> You are getting a #Value error.. since you have the following #Value
> errors in your data.
>
>
>   ASTRAZENECA PHARMA INDIA LTD 36 #VALUE!  PFIZER LIMITED 35 17.6  SUN
> PHARMA ADVANCED RESEARCH 33 #VALUE!
>
> On Fri, Jan 11, 2013 at 12:15 PM, amar takale wrote:
>
>> Hi All,
>> Pls suggest me Sumproduct formula in Row 185. I Put formula Row 183 but
>> it is so long & Confusing.Pls suggest me simple formula for solution
>>
>> Regards
>> Amar
>>
>> --
>> Join official Facebook page of this forum @
>> https://www.facebook.com/discussexcel
>>
>> FORUM RULES
>>
>> 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) Jobs posting is not allowed.
>> 6) Sharing copyrighted material and their links is not allowed.
>>
>> NOTE : Don't ever post confidential data in a workbook. Forum owners and
>> members are not responsible for any loss.
>> ---
>> You received this message because you are subscribed to the Google Groups
>> "MS EXCEL AND VBA MACROS" group.
>> To post to this group, send email to excel-macros@googlegroups.com.
>> To unsubscribe from this group, send email to
>> excel-macros+unsubscr...@googlegroups.com.
>> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
>>
>>
>>
>
>
>
> --
>
> Warm Regards,
> Aindril De
> Ph: 9811300157
>
> --
> Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 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) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To post to this group, send email to excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
>
>
>

-- 
Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

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) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.

Re: $$Excel-Macros$$ Sumproduct Formula Required

[Aindril De]

Dear Amar,

You are getting a #Value error.. since you have the following #Value errors
in your data.


  ASTRAZENECA PHARMA INDIA LTD 36 #VALUE!  PFIZER LIMITED 35 17.6  SUN
PHARMA ADVANCED RESEARCH 33 #VALUE!
On Fri, Jan 11, 2013 at 12:15 PM, amar takale  wrote:

> Hi All,
> Pls suggest me Sumproduct formula in Row 185. I Put formula Row 183 but it
> is so long & Confusing.Pls suggest me simple formula for solution
>
> Regards
> Amar
>
> --
> Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 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) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To post to this group, send email to excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
>
>
>



-- 

Warm Regards,
Aindril De
Ph: 9811300157

-- 
Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

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) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.

Re: $$Excel-Macros$$ Sumproduct function to get sum between two date

[LAKSHMAN PRASAD]

ok





 From: LAKSHMAN PRASAD 
To: "excel-macros@googlegroups.com"  
Sent: Tuesday, August 7, 2012 11:53 AM
Subject: Re: $$Excel-Macros$$ Sumproduct function to get sum between two date
 

C the attached file. ? u r missing.




 From: Kuldeep Singh 
To: excel-macros@googlegroups.com 
Sent: Monday, August 6, 2012 12:44 PM
Subject: Re: $$Excel-Macros$$ Sumproduct function to get sum between two date
 


Dear Lakshman,

Require output value 4625000 your formula is not working.

It's working fine. =SUMPRODUCT((A7:A24>=E1)*(A7:A24<=F1)*(F7:F24))

Regards,
Kuldeep Singh
Phone.: +91-120-4763789, Extn.: 789
naukrikuld...@gmail.com || www.naukri.com
PleaseConsider the environment. Please don't print this e-mail unless you 
really need to.


On Mon, Aug 6, 2012 at 12:29 PM, LAKSHMAN PRASAD  wrote:

You are missing 
>
>
>
>
>SUMPRODUCT((A7:A23>E1)*(A7:A23
>
> 
>Lakshman Prasad
>Manager (Finance)
>GAURSONS INDIA LIMITED 
>Ph: +91 12 456777 Mob. No. 9582279261
>Website: http://www.gaursonsindia.com/
>
>
>
>
> From: Ashish Bhalara 
>To: excel-macros@googlegroups.com 
>Sent: Saturday, August 4, 2012 4:02 PM
>
>Subject: $$Excel-Macros$$ Sumproduct function to get sum between two date
> 
>
>
>Dear experts,
>
>
>I need output of sum between two date by using of Sumproduct as below formula 
>but the error is occur in fuction, please see attache sheet.
>
>
> =SUMPRODUCT(A7:A23>E1)*(A7:A23
>
> 
>Thanks & regards.
>
>
>Ashish Bhalara
>9624111822
>PPlease do not print this email unless it is absolutely necessary. Spread
environmental üawareness.♣♣♣
>
>
>
-- 
>FORUM RULES (986+ 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
> 
>To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
> 
> 
>
>
>
-- 
>Join official facebook page of this forum @ 
>https://www.facebook.com/discussexcel
> 
>FORUM RULES (1120+ 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. 
> 
>
6) Jobs posting is not allowed.
> 
>7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>
> 
>NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
>owners and members are not responsible for any loss.
>--- 
>
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
>To post to this group, send email to excel-macros@googlegroups.com.
>To unsubscribe from this group, send email to 
>excel-macros+unsubscr...@googlegroups.com.
>
-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel
 
FORUM RULES (1120+ 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. 
 
6) Jobs posting is not allowed.
 
7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
 
NOTE  

Re: $$Excel-Macros$$ Sumproduct function to get sum between two date

[Kuldeep Singh]

Hi Lakshman G,

You're right. But Mr. Ashish says, Require output value 4625000, So I
solved query for required output.

Regards,
Kuldeep Singh
Back Office Executive (MIS)
Info Edge India Limited (naukri.com)
Phone.: +91-120-4763789, Extn.: 789
naukrikuld...@gmail.com || www.naukri.com
*Please* *Consider the environment. Please don't print this e-mail unless
you really need to.*

On Tue, Aug 7, 2012 at 11:53 AM, LAKSHMAN PRASAD wrote:

> C the attached file. ? u r missing.
>
>
>   --
> *From:* Kuldeep Singh 
> *To:* excel-macros@googlegroups.com
> *Sent:* Monday, August 6, 2012 12:44 PM
> *Subject:* Re: $$Excel-Macros$$ Sumproduct function to get sum between
> two date
>
>
> Dear Lakshman,
>
> Require output value 4625000 your formula is not working.
>
> It's working fine. =SUMPRODUCT((A7:A24>=E1)*(A7:A24<=F1)*(F7:F24))
>
> Regards,
> Kuldeep Singh
> Phone.: +91-120-4763789, Extn.: 789
> naukrikuld...@gmail.com || www.naukri.com
> *Please* *Consider the environment. Please don't print this e-mail unless
> you really need to.*
>
> On Mon, Aug 6, 2012 at 12:29 PM, LAKSHMAN PRASAD 
> wrote:
>
> You are missing
>
>
> SUMPRODUCT((A7:A23>E1)*(A7:A23
>
> *Lakshman Prasad*
> Manager (Finance)
> GAURSONS INDIA LIMITED
> Ph: +91 12 456777 Mob. No. 9582279261
> Website: http://www.gaursonsindia.com/
>
>   ----------
> *From:* Ashish Bhalara 
> *To:* excel-macros@googlegroups.com
> *Sent:* Saturday, August 4, 2012 4:02 PM
>
> *Subject:* $$Excel-Macros$$ Sumproduct function to get sum between two
> date
>
> Dear experts,
>
> I need output of sum between two date by using of Sumproduct as below
> formula but the error is occur in fuction, please see attache sheet.
>
>  =SUMPRODUCT(A7:A23>E1)*(A7:A23
>
> Thanks & regards.
>
> Ashish Bhalara
> 9624111822
> P*Please do not print this email unless it is absolutely necessary.
> Spread environmental üawareness.♣♣♣*
>
>
>  --
> FORUM RULES (986+ 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
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com
>
>
>
>
>   --
> Join official facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES (1120+ 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.
>
> 6) Jobs posting is not allowed.
>
> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To post to this group, send email to excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.com.
>
>  --
> Join official facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES (1120+ 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 t

Re: $$Excel-Macros$$ Sumproduct function to get sum between two date

[LAKSHMAN PRASAD]

C the attached file. ? u r missing.




 From: Kuldeep Singh 
To: excel-macros@googlegroups.com 
Sent: Monday, August 6, 2012 12:44 PM
Subject: Re: $$Excel-Macros$$ Sumproduct function to get sum between two date
 


Dear Lakshman,

Require output value 4625000 your formula is not working.

It's working fine. =SUMPRODUCT((A7:A24>=E1)*(A7:A24<=F1)*(F7:F24))

Regards,
Kuldeep Singh
Phone.: +91-120-4763789, Extn.: 789
naukrikuld...@gmail.com || www.naukri.com
PleaseConsider the environment. Please don't print this e-mail unless you 
really need to.


On Mon, Aug 6, 2012 at 12:29 PM, LAKSHMAN PRASAD  wrote:

You are missing 
>
>
>
>
>SUMPRODUCT((A7:A23>E1)*(A7:A23
>
> 
>Lakshman Prasad
>Manager (Finance)
>GAURSONS INDIA LIMITED 
>Ph: +91 12 456777 Mob. No. 9582279261
>Website: http://www.gaursonsindia.com/
>
>
>
>
> From: Ashish Bhalara 
>To: excel-macros@googlegroups.com 
>Sent: Saturday, August 4, 2012 4:02 PM
>
>Subject: $$Excel-Macros$$ Sumproduct function to get sum between two date
> 
>
>
>Dear experts,
>
>
>I need output of sum between two date by using of Sumproduct as below formula 
>but the error is occur in fuction, please see attache sheet.
>
>
> =SUMPRODUCT(A7:A23>E1)*(A7:A23
>
> 
>Thanks & regards.
>
>
>Ashish Bhalara
>9624111822
>PPlease do not print this email unless it is absolutely necessary. Spread
environmental üawareness.♣♣♣
>
>
>
-- 
>FORUM RULES (986+ 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
> 
>To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
> 
> 
>
>
>
-- 
>Join official facebook page of this forum @ 
>https://www.facebook.com/discussexcel
> 
>FORUM RULES (1120+ 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. 
> 
>
6) Jobs posting is not allowed.
> 
>7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>
> 
>NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
>owners and members are not responsible for any loss.
>--- 
>
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
>To post to this group, send email to excel-macros@googlegroups.com.
>To unsubscribe from this group, send email to 
>excel-macros+unsubscr...@googlegroups.com.
>
-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel
 
FORUM RULES (1120+ 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. 
 
6) Jobs posting is not allowed.
 
7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
 
NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACR

Re: $$Excel-Macros$$ Sumproduct function to get sum between two date

[Kuldeep Singh]

Dear Lakshman,

Require output value 4625000 your formula is not working.

It's working fine. =SUMPRODUCT((A7:A24>=E1)*(A7:A24<=F1)*(F7:F24))

Regards,
Kuldeep Singh
Phone.: +91-120-4763789, Extn.: 789
naukrikuld...@gmail.com || www.naukri.com
*Please* *Consider the environment. Please don't print this e-mail unless
you really need to.*

On Mon, Aug 6, 2012 at 12:29 PM, LAKSHMAN PRASAD wrote:

> You are missing
>
>
> SUMPRODUCT((A7:A23>E1)*(A7:A23
>
> *Lakshman Prasad*
> Manager (Finance)
> GAURSONS INDIA LIMITED
> Ph: +91 12 456777 Mob. No. 9582279261
> Website: http://www.gaursonsindia.com/
>
>   --
> *From:* Ashish Bhalara 
> *To:* excel-macros@googlegroups.com
> *Sent:* Saturday, August 4, 2012 4:02 PM
>
> *Subject:* $$Excel-Macros$$ Sumproduct function to get sum between two
> date
>
> Dear experts,
>
> I need output of sum between two date by using of Sumproduct as below
> formula but the error is occur in fuction, please see attache sheet.
>
>  =SUMPRODUCT(A7:A23>E1)*(A7:A23
>
> Thanks & regards.
>
> Ashish Bhalara
> 9624111822
> P*Please do not print this email unless it is absolutely necessary.
> Spread environmental üawareness.♣♣♣*
>
>
>  --
> FORUM RULES (986+ 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
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com
>
>
>
>
>   --
> Join official facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES (1120+ 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.
>
> 6) Jobs posting is not allowed.
>
> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To post to this group, send email to excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.com.
>

-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ 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. 

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.

Re: $$Excel-Macros$$ Sumproduct function to get sum between two date

[Ashish Bhalara]

Thanks to all, I make very silly mistake.

On Mon, Aug 6, 2012 at 12:29 PM, LAKSHMAN PRASAD wrote:

> You are missing
>
>
> SUMPRODUCT((A7:A23>E1)*(A7:A23
>
> *Lakshman Prasad*
> Manager (Finance)
> GAURSONS INDIA LIMITED
> Ph: +91 12 456777 Mob. No. 9582279261
> Website: http://www.gaursonsindia.com/
>
>   --
> *From:* Ashish Bhalara 
> *To:* excel-macros@googlegroups.com
> *Sent:* Saturday, August 4, 2012 4:02 PM
>
> *Subject:* $$Excel-Macros$$ Sumproduct function to get sum between two
> date
>
> Dear experts,
>
> I need output of sum between two date by using of Sumproduct as below
> formula but the error is occur in fuction, please see attache sheet.
>
>  =SUMPRODUCT(A7:A23>E1)*(A7:A23
>
> Thanks & regards.
>
> Ashish Bhalara
> 9624111822
> P*Please do not print this email unless it is absolutely necessary.
> Spread environmental üawareness.♣♣♣*
>
>
>  --
> FORUM RULES (986+ 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
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com
>
>
>
>
>   --
> Join official facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES (1120+ 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.
>
> 6) Jobs posting is not allowed.
>
> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To post to this group, send email to excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.com.
>
>
>



-- 
Thanks & regards.

Ashish Bhalara
9624111822
P*Please do not print this email unless it is absolutely necessary. Spread
environmental üawareness.♣♣♣*

-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ 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. 

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.

Re: $$Excel-Macros$$ Sumproduct function to get sum between two date

[LAKSHMAN PRASAD]

You are missing 


SUMPRODUCT((A7:A23>E1)*(A7:A23http://www.gaursonsindia.com/



 From: Ashish Bhalara 
To: excel-macros@googlegroups.com 
Sent: Saturday, August 4, 2012 4:02 PM
Subject: $$Excel-Macros$$ Sumproduct function to get sum between two date
 

Dear experts,

I need output of sum between two date by using of Sumproduct as below formula 
but the error is occur in fuction, please see attache sheet.

 =SUMPRODUCT(A7:A23>E1)*(A7:A23https://www.facebook.com/discussexcel

FORUM RULES (1120+ 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. 

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.

Re: $$Excel-Macros$$ Sumproduct function to get sum between two date

[Kuldeep Singh]

Hi Ashish,

Please see attachment.

Regards,
Kuldeep Singh
Phone.: +91-120-4763789, Extn.: 789
naukrikuld...@gmail.com || www.naukri.com
*Please* *Consider the environment. Please don't print this e-mail unless
you really need to.*

On Sat, Aug 4, 2012 at 4:19 PM, Rajan_Verma wrote:

> *=SUMPRODUCT((A7:A23>=E1)*(A7:A23<=F1)*(F7:F23))*
>
> * *
>
> * *
>
> *Regards*
>
> *Rajan verma*
>
> *+91 7838100659 [IM-Gtalk]*
>
> * *
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Ashish Bhalara
> *Sent:* 04 August 2012 4:02
> *To:* excel-macros@googlegroups.com
> *Subject:* $$Excel-Macros$$ Sumproduct function to get sum between two
> date
>
> ** **
>
> Dear experts,
>
> ** **
>
> I need output of sum between two date by using of Sumproduct as below
> formula but the error is occur in fuction, please see attache sheet.
>
> ** **
>
>  =SUMPRODUCT(A7:A23>E1)*(A7:A23 
>
> ** **
>
>
> Thanks & regards.
>
> ** **
>
> Ashish Bhalara
>
> 9624111822
>
> P*Please do not print this email unless it is absolutely necessary.
> Spread environmental **ü**awareness.**♣♣♣*
>
> ** **
>
> ** **
>
> --
> FORUM RULES (986+ 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
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com
>
>  
>
> --
> FORUM RULES (986+ 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
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com
>

-- 
FORUM RULES (986+ 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

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com




Sumproduct Quary solved..xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

RE: $$Excel-Macros$$ Sumproduct function to get sum between two date

[Rajan_Verma]

=SUMPRODUCT((A7:A23>=E1)*(A7:A23<=F1)*(F7:F23))

 

 

Regards

Rajan verma

+91 7838100659 [IM-Gtalk]

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On 
Behalf Of Ashish Bhalara
Sent: 04 August 2012 4:02
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Sumproduct function to get sum between two date

 

Dear experts,

 

I need output of sum between two date by using of Sumproduct as below formula 
but the error is occur in fuction, please see attache sheet.

 

 =SUMPRODUCT(A7:A23>E1)*(A7:A23

$$Excel-Macros$$ Sumproduct function to get sum between two date

[Ashish Bhalara]

Dear experts,

I need output of sum between two date by using of Sumproduct as below
formula but the error is occur in fuction, please see attache sheet.

 =SUMPRODUCT(A7:A23>E1)*(A7:A23

Sumproduct Function.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

Re: $$Excel-Macros$$ Sumproduct accross multiple sheets

[Haseeb Avarakkan]

Hi,

Assume the sheet name always be in dd-mmm-yy format. I have define a name 
CurrPeriod, you need to define it on your file. Just change Start & End 
Date reference in this formula. I also change some Locations for SALES in 
multiple sheets to make sure it works :-)

See the attached.

___
HTH, Haseeb

-- 
FORUM RULES (986+ 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


Sumproduct_Across_multiple_sheets.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

Fwd: $$Excel-Macros$$ Sumproduct accross multiple sheets

[Sundarvelan N]

Friends help me on this help.
Thanks
N.Sundarvelan
9600160150



-- Forwarded message --
From: Sundarvelan N 
Date: Fri, Mar 2, 2012 at 11:52 AM
Subject: $$Excel-Macros$$ Sumproduct accross multiple sheets
To: excel-macros@googlegroups.com


Hi Friends,

Help me in achieving this task.

sumproduct across multiple sheets


Thanks
N.Sundarvelan
9600160150

 --
FORUM RULES (986+ 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 (986+ 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


SUMPRODUCT.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

$$Excel-Macros$$ Sumproduct accross multiple sheets

[Sundarvelan N]

Hi Friends,

Help me in achieving this task.

sumproduct across multiple sheets


Thanks
N.Sundarvelan
9600160150

-- 
FORUM RULES (986+ 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


SUMPRODUCT.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

Re: $$Excel-Macros$$ Sumproduct for multiple criteria lookup

[Darwin Chan]

Thanks Noorain,

I got the problem solved!!

2011/12/9 NOORAIN ANSARI 

>
> Dear Darwin,
>
> Please see attached sheet. Hope it will help you..
>
>
> --
> Thanks & regards,
> Noorain Ansari
>  *http://excelmacroworld.blogspot.com/*
> *http://noorain-ansari.blogspot.com/*
> On Fri, Dec 9, 2011 at 8:03 AM, Darwin Chan 
> wrote:
>
>> Dear group,
>>
>> I have got an excel file getting sales volume of different customers in
>> buying different services on a daily basis. I want to use sumproduct
>> formula to get the sales volume buying services on a monthly basis.
>> However, the desired results are not found. Please help.
>>
>>
>> --
>> Darwin Chan
>> darwin.chankaw...@gmail.com
>> kw42c...@yahoo.com.hk
>>
>> --
>> 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
>



-- 
Darwin Chan
darwin.chankaw...@gmail.com
kw42c...@yahoo.com.hk

-- 
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

Re: $$Excel-Macros$$ Sumproduct for multiple criteria lookup

[NOORAIN ANSARI]

Dear Darwin,

Please see attached sheet. Hope it will help you..


-- 
Thanks & regards,
Noorain Ansari
 *http://excelmacroworld.blogspot.com/*
*http://noorain-ansari.blogspot.com/* 
On Fri, Dec 9, 2011 at 8:03 AM, Darwin Chan wrote:

> Dear group,
>
> I have got an excel file getting sales volume of different customers in
> buying different services on a daily basis. I want to use sumproduct
> formula to get the sales volume buying services on a monthly basis.
> However, the desired results are not found. Please help.
>
>
> --
> Darwin Chan
> darwin.chankaw...@gmail.com
> kw42c...@yahoo.com.hk
>
> --
> 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


Excel Sumproduct questions(Solve).xls
Description: MS-Excel spreadsheet

$$Excel-Macros$$ Sumproduct for multiple criteria lookup

[Darwin Chan]

Dear group,

I have got an excel file getting sales volume of different customers in
buying different services on a daily basis. I want to use sumproduct
formula to get the sales volume buying services on a monthly basis.
However, the desired results are not found. Please help.


-- 
Darwin Chan
darwin.chankaw...@gmail.com
kw42c...@yahoo.com.hk

-- 
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


Excel Sumproduct questions.xls
Description: MS-Excel spreadsheet

RE: $$Excel-Macros$$ Sumproduct using VBA

[Daniel]

Hello,

 

Use :

 

a = "SUMPRODUCT(--(" & rng1 & "=""" & "BEL" & """),--(" & rng2 & "=""" &
"AAO" & """),--(" & rng4 & "))"

 

HTH

 

Daniel

 

De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De
la part de Chandra Shekar
Envoyé : lundi 29 août 2011 16:37
À : excel-macros@googlegroups.com
Objet : $$Excel-Macros$$ Sumproduct using VBA

 

Hello,

 

Could you please let me know whats the error in using sumproduct function in
below code. I am getting error number 2015

 

Is there any other way to use sumproduct function using vba with multiple
condtions.

 

Thanks in advance.

 

Sub ABNAMROAdd()

Dim compnm As String
lastcl = ThisWorkbook.Worksheets("ABN AMRO").Cells(4,
Columns.Count).End(xlToLeft).Column
'WeekNum = Weeknumber(Date)
'WeekNum = CurWk

x = ThisWorkbook.Name
y = ThisWorkbook.Worksheets(12).Name
Z = "'[" & x & "]" & y & "'!"

 

lastrow = ThisWorkbook.Worksheets("AR").Cells(Rows.Count, 1).End(xlUp).Row

rng1 = Z & "A2:A" & lastrow
rng2 = Z & "C2:C" & lastrow
rng3 = Z & "D2:D" & lastrow
rng4 = Z & "E2:E" & lastrow
rng5 = Z & "H2:H" & lastrow

a = "SUMPRODUCT(--(" & rng1 & "=""" & "BEL" & """),--(" & rng2 & "=""" &
"AAO" & """),--(" & rng4 & """))"
cnt = Application.Evaluate(a)


End Sub

-- 

--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at  <http://exceldailytip.blogspot.com>
http://exceldailytip.blogspot.com

To post to this group, send email to  <mailto:excel-macros@googlegroups.com>
excel-macros@googlegroups.com
 
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
 <http://www.facebook.com/discussexcel> http://www.facebook.com/discussexcel

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

$$Excel-Macros$$ Sumproduct using VBA

[Chandra Shekar]

Hello,

Could you please let me know whats the error in using sumproduct function in
below code. I am getting error number 2015

Is there any other way to use sumproduct function using vba with multiple
condtions.

Thanks in advance.

Sub ABNAMROAdd()
Dim compnm As String
lastcl = ThisWorkbook.Worksheets("ABN AMRO").Cells(4,
Columns.Count).End(xlToLeft).Column
'WeekNum = Weeknumber(Date)
'WeekNum = CurWk
x = ThisWorkbook.Name
y = ThisWorkbook.Worksheets(12).Name
Z = "'[" & x & "]" & y & "'!"

lastrow = ThisWorkbook.Worksheets("AR").Cells(Rows.Count, 1).End(xlUp).Row
rng1 = Z & "A2:A" & lastrow
rng2 = Z & "C2:C" & lastrow
rng3 = Z & "D2:D" & lastrow
rng4 = Z & "E2:E" & lastrow
rng5 = Z & "H2:H" & lastrow
a = "SUMPRODUCT(--(" & rng1 & "=""" & "BEL" & """),--(" & rng2 & "=""" &
"AAO" & """),--(" & rng4 & """))"
cnt = Application.Evaluate(a)

End Sub

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ sumproduct issue

[dguillett1]

try
$F$4581="Lost")+(Data!$F$2:$F$4581="

From: Shiek Peer Mohd 
Sent: Tuesday, August 09, 2011 1:16 AM
To: excel-macros@googlegroups.com 
Subject: $$Excel-Macros$$ sumproduct issue


Hi Experts,

I have the issues in using the multiple criteria in sumproduct. Sample file 
attached.

 
Regards,

Shiek
-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

To post to this group, send email to excel-macros@googlegroups.com
 
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ sumproduct issue

[Shiek Peer Mohd]

Hi Noorain,

It works.  Thanks a lot for your support

On Tue, Aug 9, 2011 at 12:13 PM, NOORAIN ANSARI wrote:

> Dear Peer Mohd,
>
> Please see attached sheet
>
> On Tue, Aug 9, 2011 at 11:46 AM, Shiek Peer Mohd wrote:
>
>>
>> Hi Experts,
>>
>> I have the issues in using the multiple criteria in sumproduct. Sample
>> file attached.
>>
>>
>> Regards,
>>
>> Shiek
>>
>> --
>>
>> --
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> Like our page on facebook , Just follow below link
>> http://www.facebook.com/discussexcel
>>
>
>
>
> --
> Thanks & regards,
> Noorain Ansari
> *http://noorain-ansari.blogspot.com/*
>
>  --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>



-- 
Regards,

Shiek

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ sumproduct and pivot table on same data ranges - different results - (part 2)

[bpascal123]

thanks Mahesh,

btw, I guess it would be better to use getpivotdata function instead
of a sumproduct function that requires the entire excel application to
update data if any modification to the data or the function is made...
thanks again

On 15 juil, 15:08, Mahesh parab  wrote:
> Hi
>
> U have consider G1 = 2527 in pivot table & not in sumproduct sheet. Please
> check
>
> Thanks
> Mahesh
>
> On Fri, Jul 15, 2011 at 6:20 PM, Pascal Baro wrote:
>
> > Hi,
>
> > This time there really is a difference between the pivot table and
> > productsum function.
> > It seems it's all about decimal values. Productsum seems to round up
> > numbers in a different way than the pivot table. For large numbers we
> > then get a difference.
> > Please look a the file for more ...
>
> > Pascal
>
> > --
>
> > --
> > Some important links for excel users:
> > 1. Follow us on TWITTER for tips tricks and links :
> >http://twitter.com/exceldailytip
> > 2. Join our LinkedIN group @http://www.linkedin.com/groups?gid=1871310
> > 3. Excel tutorials athttp://www.excel-macros.blogspot.com
> > 4. Learn VBA Macros athttp://www.quickvba.blogspot.com
> > 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com
>
> > To post to this group, send email to excel-macros@googlegroups.com
>
> > <><><><><><><><><><><><><><><><><><><><><><>
> > Like our page on facebook , Just follow below link
> >http://www.facebook.com/discussexcel

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ sumproduct and pivot table on same data ranges - different results - (part 2)

[Mahesh parab]

Hi

U have consider G1 = 2527 in pivot table & not in sumproduct sheet. Please
check


Thanks
Mahesh

On Fri, Jul 15, 2011 at 6:20 PM, Pascal Baro wrote:

> Hi,
>
> This time there really is a difference between the pivot table and
> productsum function.
> It seems it's all about decimal values. Productsum seems to round up
> numbers in a different way than the pivot table. For large numbers we
> then get a difference.
> Please look a the file for more ...
>
> Pascal
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

$$Excel-Macros$$ sumproduct and pivot table on same data ranges - different results - any reasons

[bpascal123]

Hi,

Why is sumproduct returning a value greater thant a pivot table on the
same data range ? Is it about the number of rows (over 30,000)?

I'd like to be more specific but maybe I can post the file in this
group, if someone can tell me how.

Regards,
Thanks

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

$$Excel-Macros$$ Sumproduct Query ********** Ashish Koul

[hanumant shinde]

Hi Ashish koul,

I have seen many of your replies and it mostly contains Sumproduct formula. i 
checked this formula in Microsoft Help (MS Help) and it seems very easy thing. 
but what you use in your answer is very much different than what is given in 
the 
MS help.
could u please explain why and what is this different.

i am giving both formulas.
MS Help:-
=SUMPRODUCT(A2:B4, C2:D4) 
in the above formula A col is multiplied with C col and B col is multiplied 
with 
D col and their products get added

Your Formula:-
=SUMPRODUCT(($G$4:$I$10=C4)*ROW($G$4:$I$10))

if i type =ROW($G$4:$I$10) i get 4 wherever i paste this formula.

you always use this * sign whereas this is not given in the MS help.
could you please explain your formula in plain English.

please please please explain your logic i have spend lot of time on this but 
really couldn't get anything :(

Thanks in advance.

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ Sumproduct with 3 criteria +

[Nadine S]

This seems to be missing your text, Kumar.  :(





From: Kumar Punnam 
To: excel-macros@googlegroups.com
Sent: Thu, August 5, 2010 6:29:35 AM
Subject: Re: $$Excel-Macros$$ Sumproduct with 3 criteria +




On Tue, Aug 3, 2010 at 5:54 PM, Nadine S  wrote:

Let me try this again.
>
>Sheet 1 has info in B, C and D that needs to match info Sheet 2 column F, G, 
>and 
>H.  If those all match then I need to check if column AH in Sheet 1 matches 
>either R2, R1 or R4 in Sheet 2.  If so, then I need to sum column X in Sheet 
>1.  
>The result needs to show on Sheet 2 in colum R and all the rows beneath where 
>there is data.  did that make more sense?  I'll create a little sample and 
>attach it since I don't have the original on this computer.
>
>Thanks so much.
>
>
>
>

From: Dave Bonallack 
>To: "excel-macros@googlegroups.com" 
>Sent: Tue, August 3, 2010 2:40:30 AM
>Subject: RE: $$Excel-Macros$$ Sumproduct with 3 criteria +
>
>
>Hi Nadine,
>I'm guessing a bit.
> 
>"What I need is a total of the result of that"
>I assume this means the result of your SumProduct formula
> 
>"plus the same if it = $R$2 and if it = $R$1"
>I assume that if the result of the SumProduct formula = R2 AND = R3, then you 
>want the result of the SumProduct formula x 2
> 
>Is that it?
>Also, can you tell me the name of the sheet where the SumProduct actually 
>resides?
>Regards - Dave.
> 
>
Date: Mon, 2 Aug 2010 09:51:34 -0700
>From: n8dine4ma...@yahoo.com
>Subject: $$Excel-Macros$$ Sumproduct with 3 criteria +
>To: excel-macros@googlegroups.com
>
>
>I have a workbook that needs a sumproduct.
>
>I have:
>=SUMPRODUCT(('Sheet3'!$A$2:$A$1000='Summary'!$F2)*('Sheet3'!$B$2:$B$1000='Summary'!$G2)*('Sheet3'!$C$2:$C$1000='Summary'!$H2)*('Sheet3'!$AD$2:$AD$1000='Summary'!R$4),('Sheet3'!$AB$2:$AB$1000))
>
>
>What I need is a total of the result of that plus the same if it = $R$2 and if 
>it = $R$1.
>
>Any ides for Excel 2003?  Thanks
>
>
>-- 
>--
>
>Some important links for excel users:
>1. Follow us on TWITTER for tips tricks and links : 
>http://twitter.com/exceldailytip
>2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>3. Excel tutorials at http://www.excel-macros.blogspot.com/
>4. Learn VBA Macros at http://www.quickvba.blogspot.com/
>5. Excel Tips and Tricks at http://exceldailytip.blogspot.com/
>
>To post to this group, send email to excel-macros@googlegroups.com
> 
><><><><><><><><><><><><><><><><><><><><><><>
>HELP US GROW !!
> 
>We reach over 7000 subscribers worldwide and receive many nice notes about the 
>learning and support from the group.Let friends and co-workers know they can 
>subscribe to group at http://groups.google.com/group/excel-macros/subscribe
>-- 
>--
>
>Some important links for excel users:
>1. Follow us on TWITTER for tips tricks and links : 
>http://twitter.com/exceldailytip
>2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>3. Excel tutorials at http://www.excel-macros.blogspot.com/
>4. Learn VBA Macros at http://www.quickvba.blogspot.com/
>5. Excel Tips and Tricks at http://exceldailytip.blogspot.com/
>
>To post to this group, send email to excel-macros@googlegroups.com
> 
><><><><><><><><><><><><><><><><><><><><><><>
>HELP US GROW !!
> 
>We reach over 7000 subscribers worldwide and receive many nice notes about the 
>learning and support from the group.Let friends and co-workers know they can 
>subscribe to group at http://groups.google.com/group/excel-macros/subscribe
>
>
>-- 
>--
>
>Some important links for excel users:
>1. Follow us on TWITTER for tips tricks and links : 
>http://twitter.com/exceldailytip
>2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>3. Excel tutorials at http://www.excel-macros.blogspot.com
>4. Learn VBA Macros at http://www.quickvba.blogspot.com
>5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
>To post to this group, send email to excel-macros@googlegroups.com
> 
>

Re: $$Excel-Macros$$ Sumproduct with 3 criteria +

[Nadine S]

Hi Dave,

Thanks for responding.  No, I haven't gotten an answer so thank you, thank you, 
thank you for helping me.

Sheet 1 contains the details and Sheet 2 is the summary.  So, Sheet 1 B, C, D 
has information that may show the same on multiple lines due to different 
information in the others cells on the rows.  So what you find in B, C, D on 
row 
2 might be found on row 3 or 15 or 700 etc.  Now sheet 2 columns F, G, H have 
only one listing of the unique combination in Shee 1 B, C, D.  Make sense so 
far?

Now Sheet 1 col X and AH contain data.  But I need to combine all this data on 
my summary page Sheet 2.  So, sheet 2 col R needs to sum the data in sheet 1 
col 
X if the info in sheet 1 col AH matches sheet 2 col R cell 1, 2, or 4.

Let me put some sample data in the sheet to show what I need as the solution in 
sheet 2 cell R6.

Thank you so much.

Nadine





From: Dave Bonallack 
To: "excel-macros@googlegroups.com" 
Sent: Thu, August 5, 2010 4:53:35 AM
Subject: RE: $$Excel-Macros$$ Sumproduct with 3 criteria +

Hi Nadine,
Sorry I haven't got back to you on this. And I don't even know if it has been 
answered by someone else. If you still need an answer, then I need to know what 
you want summed in Col X.
If everything matches up as you have described, then the cell fom Col X is just 
one cell, which I don't see how you can sum. Sorry I'm not understanding.
Regards - Dave.
 

Date: Tue, 3 Aug 2010 05:24:47 -0700
From: n8dine4ma...@yahoo.com
Subject: Re: $$Excel-Macros$$ Sumproduct with 3 criteria +
To: excel-macros@googlegroups.com


Let me try this again.

Sheet 1 has info in B, C and D that needs to match info Sheet 2 column F, G, 
and 
H.  If those all match then I need to check if column AH in Sheet 1 matches 
either R2, R1 or R4 in Sheet 2.  If so, then I need to sum column X in Sheet 
1.  
The result needs to show on Sheet 2 in colum R and all the rows beneath where 
there is data.  did that make more sense?  I'll create a little sample and 
attach it since I don't have the original on this computer.

Thanks so much.





From: Dave Bonallack 
To: "excel-macros@googlegroups.com" 
Sent: Tue, August 3, 2010 2:40:30 AM
Subject: RE: $$Excel-Macros$$ Sumproduct with 3 criteria +

Hi Nadine,
I'm guessing a bit.
 
"What I need is a total of the result of that"
I assume this means the result of your SumProduct formula
 
"plus the same if it = $R$2 and if it = $R$1"
I assume that if the result of the SumProduct formula = R2 AND = R3, then you 
want the result of the SumProduct formula x 2
 
Is that it?
Also, can you tell me the name of the sheet where the SumProduct actually 
resides?
Regards - Dave.
 
____
Date: Mon, 2 Aug 2010 09:51:34 -0700
From: n8dine4ma...@yahoo.com
Subject: $$Excel-Macros$$ Sumproduct with 3 criteria +
To: excel-macros@googlegroups.com


I have a workbook that needs a sumproduct.

I have:
=SUMPRODUCT(('Sheet3'!$A$2:$A$1000='Summary'!$F2)*('Sheet3'!$B$2:$B$1000='Summary'!$G2)*('Sheet3'!$C$2:$C$1000='Summary'!$H2)*('Sheet3'!$AD$2:$AD$1000='Summary'!R$4),('Sheet3'!$AB$2:$AB$1000))


What I need is a total of the result of that plus the same if it = $R$2 and if 
it = $R$1.

Any ides for Excel 2003?  Thanks


-- 
--

Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com/
4. Learn VBA Macros at http://www.quickvba.blogspot.com/
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com/

To post to this group, send email to excel-macros@googlegroups.com
 
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!
 
We reach over 7000 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

-- 
--

Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com/
4. Learn VBA Macros at http://www.quickvba.blogspot.com/
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com/

To post to this group, send email to excel-macros@googlegroups.

Re: $$Excel-Macros$$ Sumproduct with 3 criteria +

[Kumar Punnam]

On Tue, Aug 3, 2010 at 5:54 PM, Nadine S  wrote:

>  Let me try this again.
>
> Sheet 1 has info in B, C and D that needs to match info Sheet 2 column F,
> G, and H.  If those all match then I need to check if column AH in Sheet 1
> matches either R2, R1 or R4 in Sheet 2.  If so, then I need to sum column X
> in Sheet 1.  The result needs to show on Sheet 2 in colum R and all the rows
> beneath where there is data.  did that make more sense?  I'll create a
> little sample and attach it since I don't have the original on this
> computer.
>
> Thanks so much.
>
>  --
> *From:* Dave Bonallack 
> *To:* "excel-macros@googlegroups.com" 
> *Sent:* Tue, August 3, 2010 2:40:30 AM
> *Subject:* RE: $$Excel-Macros$$ Sumproduct with 3 criteria +
>
> Hi Nadine,
> I'm guessing a bit.
>
> "What I need is a total of the result of that"
> I assume this means the result of your SumProduct formula
>
> "plus the same if it = $R$2 and if it = $R$1"
> I assume that if the result of the SumProduct formula = R2 AND = R3, then
> you want the result of the SumProduct formula x 2
>
> Is that it?
> Also, can you tell me the name of the sheet where the SumProduct actually
> resides?
> Regards - Dave.
>
> --
> Date: Mon, 2 Aug 2010 09:51:34 -0700
> From: n8dine4ma...@yahoo.com
> Subject: $$Excel-Macros$$ Sumproduct with 3 criteria +
> To: excel-macros@googlegroups.com
>
>  I have a workbook that needs a sumproduct.
>
> I have:
>
>
> =SUMPRODUCT(('Sheet3'!$A$2:$A$1000='Summary'!$F2)*('Sheet3'!$B$2:$B$1000='Summary'!$G2)*('Sheet3'!$C$2:$C$1000='Summary'!$H2)*('Sheet3'!$AD$2:$AD$1000='Summary'!R$4),('Sheet3'!$AB$2:$AB$1000))
>
> What I need is a total of the result of that plus the same if it = $R$2 and
> if it = $R$1.
>
> Any ides for Excel 2003?  Thanks
>
>
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com/
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com/
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com/
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 7000 subscribers worldwide and receive many nice notes about
> the learning and support from the group.Let friends and co-workers know they
> can subscribe to group at
> http://groups.google.com/group/excel-macros/subscribe
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 7000 subscribers worldwide and receive many nice notes about
> the learning and support from the group.Let friends and co-workers know they
> can subscribe to group at
> http://groups.google.com/group/excel-macros/subscribe
>
>   --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>

RE: $$Excel-Macros$$ Sumproduct with 3 criteria +

[Dave Bonallack]

Hi Nadine,

Sorry I haven't got back to you on this. And I don't even know if it has been 
answered by someone else. If you still need an answer, then I need to know what 
you want summed in Col X.

If everything matches up as you have described, then the cell fom Col X is just 
one cell, which I don't see how you can sum. Sorry I'm not understanding.

Regards - Dave.
 


Date: Tue, 3 Aug 2010 05:24:47 -0700
From: n8dine4ma...@yahoo.com
Subject: Re: $$Excel-Macros$$ Sumproduct with 3 criteria +
To: excel-macros@googlegroups.com






Let me try this again.
 
Sheet 1 has info in B, C and D that needs to match info Sheet 2 column F, G, 
and H.  If those all match then I need to check if column AH in Sheet 1 matches 
either R2, R1 or R4 in Sheet 2.  If so, then I need to sum column X in Sheet 1. 
 The result needs to show on Sheet 2 in colum R and all the rows beneath where 
there is data.  did that make more sense?  I'll create a little sample and 
attach it since I don't have the original on this computer.
 
Thanks so much.





From: Dave Bonallack 
To: "excel-macros@googlegroups.com" 
Sent: Tue, August 3, 2010 2:40:30 AM
Subject: RE: $$Excel-Macros$$ Sumproduct with 3 criteria +



Hi Nadine,
I'm guessing a bit.
 
"What I need is a total of the result of that"
I assume this means the result of your SumProduct formula
 
"plus the same if it = $R$2 and if it = $R$1"
I assume that if the result of the SumProduct formula = R2 AND = R3, then you 
want the result of the SumProduct formula x 2
 
Is that it?
Also, can you tell me the name of the sheet where the SumProduct actually 
resides?
Regards - Dave.
 


Date: Mon, 2 Aug 2010 09:51:34 -0700
From: n8dine4ma...@yahoo.com
Subject: $$Excel-Macros$$ Sumproduct with 3 criteria +
To: excel-macros@googlegroups.com





I have a workbook that needs a sumproduct.
 
I have:
=SUMPRODUCT(('Sheet3'!$A$2:$A$1000='Summary'!$F2)*('Sheet3'!$B$2:$B$1000='Summary'!$G2)*('Sheet3'!$C$2:$C$1000='Summary'!$H2)*('Sheet3'!$AD$2:$AD$1000='Summary'!R$4),('Sheet3'!$AB$2:$AB$1000))
 
What I need is a total of the result of that plus the same if it = $R$2 and if 
it = $R$1.
 
Any ides for Excel 2003?  Thanks
 

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com/
4. Learn VBA Macros at http://www.quickvba.blogspot.com/
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com/

To post to this group, send email to excel-macros@googlegroups.com
 
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!
 
We reach over 7000 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe


-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

To post to this group, send email to excel-macros@googlegroups.com
 
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!
 
We reach over 7000 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe



-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

To post to this group, send email to excel-macros@googlegroups.com
 
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!
 
We reach over 7000

Re: $$Excel-Macros$$ Sumproduct with 3 criteria +

[Nadine S]

Let me try this again.

Sheet 1 has info in B, C and D that needs to match info Sheet 2 column F, G, 
and 
H.  If those all match then I need to check if column AH in Sheet 1 matches 
either R2, R1 or R4 in Sheet 2.  If so, then I need to sum column X in Sheet 
1.  
The result needs to show on Sheet 2 in colum R and all the rows beneath where 
there is data.  did that make more sense?  I'll create a little sample and 
attach it since I don't have the original on this computer.

Thanks so much.





From: Dave Bonallack 
To: "excel-macros@googlegroups.com" 
Sent: Tue, August 3, 2010 2:40:30 AM
Subject: RE: $$Excel-Macros$$ Sumproduct with 3 criteria +

Hi Nadine,
I'm guessing a bit.
 
"What I need is a total of the result of that"
I assume this means the result of your SumProduct formula
 
"plus the same if it = $R$2 and if it = $R$1"
I assume that if the result of the SumProduct formula = R2 AND = R3, then you 
want the result of the SumProduct formula x 2
 
Is that it?
Also, can you tell me the name of the sheet where the SumProduct actually 
resides?
Regards - Dave.
 

Date: Mon, 2 Aug 2010 09:51:34 -0700
From: n8dine4ma...@yahoo.com
Subject: $$Excel-Macros$$ Sumproduct with 3 criteria +
To: excel-macros@googlegroups.com


I have a workbook that needs a sumproduct.

I have:
=SUMPRODUCT(('Sheet3'!$A$2:$A$1000='Summary'!$F2)*('Sheet3'!$B$2:$B$1000='Summary'!$G2)*('Sheet3'!$C$2:$C$1000='Summary'!$H2)*('Sheet3'!$AD$2:$AD$1000='Summary'!R$4),('Sheet3'!$AB$2:$AB$1000))


What I need is a total of the result of that plus the same if it = $R$2 and if 
it = $R$1.

Any ides for Excel 2003?  Thanks


-- 
--

Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com/
4. Learn VBA Macros at http://www.quickvba.blogspot.com/
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com/

To post to this group, send email to excel-macros@googlegroups.com
 
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!
 
We reach over 7000 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe
-- 
--

Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

To post to this group, send email to excel-macros@googlegroups.com
 
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!
 
We reach over 7000 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe



  

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 7000 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe


sample for sumif+.xls
Description: MS-Excel spreadsheet

RE: $$Excel-Macros$$ Sumproduct with 3 criteria +

[Dave Bonallack]

Hi Nadine,

I'm guessing a bit.

 

"What I need is a total of the result of that"

I assume this means the result of your SumProduct formula

 

"plus the same if it = $R$2 and if it = $R$1"

I assume that if the result of the SumProduct formula = R2 AND = R3, then you 
want the result of the SumProduct formula x 2

 

Is that it?

Also, can you tell me the name of the sheet where the SumProduct actually 
resides?

Regards - Dave.
 


Date: Mon, 2 Aug 2010 09:51:34 -0700
From: n8dine4ma...@yahoo.com
Subject: $$Excel-Macros$$ Sumproduct with 3 criteria +
To: excel-macros@googlegroups.com






I have a workbook that needs a sumproduct.
 
I have:
=SUMPRODUCT(('Sheet3'!$A$2:$A$1000='Summary'!$F2)*('Sheet3'!$B$2:$B$1000='Summary'!$G2)*('Sheet3'!$C$2:$C$1000='Summary'!$H2)*('Sheet3'!$AD$2:$AD$1000='Summary'!R$4),('Sheet3'!$AB$2:$AB$1000))
 
What I need is a total of the result of that plus the same if it = $R$2 and if 
it = $R$1.
 
Any ides for Excel 2003?  Thanks
 


-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

To post to this group, send email to excel-macros@googlegroups.com
 
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!
 
We reach over 7000 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe
  

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 7000 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

$$Excel-Macros$$ Sumproduct with 3 criteria +

[Nadine S]

I have a workbook that needs a sumproduct.

I have:
=SUMPRODUCT(('Sheet3'!$A$2:$A$1000='Summary'!$F2)*('Sheet3'!$B$2:$B$1000='Summary'!$G2)*('Sheet3'!$C$2:$C$1000='Summary'!$H2)*('Sheet3'!$AD$2:$AD$1000='Summary'!R$4),('Sheet3'!$AB$2:$AB$1000))


What I need is a total of the result of that plus the same if it = $R$2 and if 
it = $R$1.

Any ides for Excel 2003?  Thanks



  

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 7000 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

Re: $$Excel-Macros$$ Sumproduct

[Vikas Chouhan]

Chk it,,

Multiplies all the components of the two arrays and then adds the products —

On Wed, Apr 21, 2010 at 10:10 AM, Jai  wrote:

> Dear All, Can you tell me that what is the work of sum product.
>
> --
> Thanks For Mail.
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 6,800 subscribers worldwide and receive many nice notes about
> the learning and support from the group.Let friends and co-workers know they
> can subscribe to group at
> http://groups.google.com/group/excel-macros/subscribe
>



-- 
One Team One Dream One Goal

Warm Regards,
Vikas Chauhan
E-Mail :- vikask...@gmail.com,vikask...@rediffmail.com,
9911868518,
"We can't Spell S_ccess without U"

Life is Very beautiful !!!
¨`•.•´¨) Always
`•.¸(¨`•.•´¨) Keep
(¨`•.•´¨)¸.•´ Smiling!
`•.¸.•´.

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,800 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe


Book3.xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ Sumproduct

[Swapnil Palande]

Hi Jai,

Sum product formula will give you sum of product of two columns or arrays.

For ex:

Check the following table :

A B   C
Product   QtyPrice / unit
A 2 45
B 5 50
C 10   35
D 6 40
E 7 65

Now in above table if you want the total value of sales. Then in this case
you can use sumproduct formula.

formula will be: =sumproduct(B1:B6, C1:C6)

In above formula "B1:B6" is a range of qty column and "C1:C6" is a range of
price column.

Check the attached excel.

Regards,

Swapnil.

On Wed, Apr 21, 2010 at 10:10 AM, Jai  wrote:

> Dear All, Can you tell me that what is the work of sum product.
>
> --
> Thanks For Mail.
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 6,800 subscribers worldwide and receive many nice notes about
> the learning and support from the group.Let friends and co-workers know they
> can subscribe to group at
> http://groups.google.com/group/excel-macros/subscribe
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,800 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe


Sumproduct.xls
Description: MS-Excel spreadsheet

$$Excel-Macros$$ Sumproduct

[Jai]

Dear All, Can you tell me that what is the work of sum product.

-- 
Thanks For Mail.

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,800 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

$$Excel-Macros$$ sumproduct clarification

[Vinu]

Hello,

I have enclosed the copy of xl sheet, hope which will clarify your
question.  If you need any clarification or If am wrong please let me know.

Thanks & Regards
-- 
Vinu


(¨`*.*´¨) Always
`*.¸(¨`*.*´¨) Keep
(¨`*.*´¨)¸.*´ Smiling!
`*.¸.*´

--~--~-~--~~~---~--~~
-
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
-
-~--~~~~--~~--~--~---



Sumproduct details.xls
Description: MS-Excel spreadsheet