Re: $$Excel-Macros$$ Re: Sumif not working

2012-12-26 Thread Ms-Exl-Learner 

@Prince,

Thanks for the understanding :)


On 26-12-2012 2:27 PM, Prince wrote:

Yes Dear Ms-Exl-Learner,

I also belive in correcting the things so that anything we do should 
be perfect and smooth. It is best form me that guys like you are 
always there who can ping me whenever i do any thing wrong .


Thanks again for correcting me.

:)

Regards
Prince

On Wednesday, December 26, 2012 2:06:31 PM UTC+5:30, Ms-Exl-Learner 
wrote:


@Prince,

I am not talking about the ways or methods of getting the result,
which I never did, since that is the speciality of excel we can
get the same result in many ways.

But the previous post is not related to the method or ways of
pulling the data, It's about the *errors and wrong usage***of
functions.  Whenever I see any formula with error I just point
out, so that you will be aware of the drawbacks which will help
you when building formula's in future.


On 26-12-2012 1:38 PM, Prince wrote:

Hi Ms-Exl-Learner,

Yes dear,  you are right. There are so many ways to do the same
thing. And thanks alot for your kind information :)

Regards
Prince

On Wednesday, December 26, 2012 12:48:10 PM UTC+5:30,
Ms-Exl-Learner wrote:

@Prince,

Why not just added another "m" in your text function
*TEXT(C16:C35,"mmm")* which will avoid unnecessary MID
Function.  One more thing I don't think you need any case
sensitivity function here (Proper in your formula).

(TEXT(C16:C35,"mmm")=MID(PROPER(B2),1,3))*1)

TEXT(C16:C35,"mmm") = This one is text output
MID(PROPER(B2),1,3))*1 = What is the purpose of *1 in this???

Does it make any sense?

On Wed, Dec 26, 2012 at 12:22 PM, Prince
 wrote:

Hi Rajesh,

It may help you,.

=SUM((D16:D35)*(TEXT(C16:C35,"mmm")=MID(PROPER(B2),1,3))*1)
with cse

Regards
Prince


On Wednesday, December 26, 2012 11:24:19 AM UTC+5:30,
kasper wrote:

Hi Experts,

In the attachment file the sumif formula is not
working I don't know
why.kindly point the mistakes in it.

Regards

Rajesh

-- 
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-...@googlegroups.com.
To unsubscribe from this group, send email to
excel-macros...@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-...@googlegroups.com
.
To unsubscribe from this group, send email to
excel-macros...@googlegroups.com .
Visit this group at
http://groups.google.com/group/excel-macros?hl=en
.




--
Jo

Re: $$Excel-Macros$$ Re: Sumif not working

2012-12-26 Thread Prince 
Yes Dear Ms-Exl-Learner,

I also belive in correcting the things so that anything we do should be 
perfect and smooth. It is best form me that guys like you are always there 
who can ping me whenever i do any thing wrong .

Thanks again for correcting me.

:)

Regards
Prince

On Wednesday, December 26, 2012 2:06:31 PM UTC+5:30, Ms-Exl-Learner wrote:
>
>  @Prince,
>
> I am not talking about the ways or methods of getting the result, which I 
> never did, since that is the speciality of excel we can get the same result 
> in many ways.  
>
> But the previous post is not related to the method or ways of pulling the 
> data, It's about the *errors and wrong usage** *of functions.  Whenever I 
> see any formula with error I just point out, so that you will be aware of 
> the drawbacks which will help you when building formula's in future.
>
>
> On 26-12-2012 1:38 PM, Prince wrote:
>  
> Hi Ms-Exl-Learner, 
>
>  Yes dear,  you are right. There are so many ways to do the same thing. 
> And thanks alot for your kind information :)
>
>  Regards
> Prince
>
> On Wednesday, December 26, 2012 12:48:10 PM UTC+5:30, Ms-Exl-Learner 
> wrote: 
>>
>> @Prince,
>>
>> Why not just added another "m" in your text function *TEXT(C16:C35,"mmm")
>> * which will avoid unnecessary MID Function.  One more thing I don't 
>> think you need any case sensitivity function here (Proper in your formula).
>>
>> (TEXT(C16:C35,"mmm")=MID(PROPER(B2),1,3))*1)
>>
>> TEXT(C16:C35,"mmm") = This one is text output 
>> MID(PROPER(B2),1,3))*1 = What is the purpose of *1 in this???
>>
>> Does it make any sense?
>>
>> On Wed, Dec 26, 2012 at 12:22 PM, Prince  wrote:
>>
>>> Hi Rajesh, 
>>>
>>>  It may help you,.
>>>
>>>  =SUM((D16:D35)*(TEXT(C16:C35,"mmm")=MID(PROPER(B2),1,3))*1) with cse
>>>
>>>  Regards
>>> Prince  
>>>
>>>
>>> On Wednesday, December 26, 2012 11:24:19 AM UTC+5:30, kasper wrote: 

 Hi Experts, 

 In the attachment file the sumif formula is not working I don't know 
 why.kindly point the mistakes in it. 

 Regards 

 Rajesh 

>>>   -- 
>>> 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-...@googlegroups.com.
>>> To unsubscribe from this group, send email to 
>>> excel-macros...@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-...@googlegroups.com
> .
> To unsubscribe from this group, send email to 
> excel-macros...@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 owner

Re: $$Excel-Macros$$ Re: Sumif not working

2012-12-26 Thread Ms-Exl-Learner 

@Prince,

I am not talking about the ways or methods of getting the result, which 
I never did, since that is the speciality of excel we can get the same 
result in many ways.


But the previous post is not related to the method or ways of pulling 
the data, It's about the *errors and wrong usage***of functions.  
Whenever I see any formula with error I just point out, so that you will 
be aware of the drawbacks which will help you when building formula's in 
future.



On 26-12-2012 1:38 PM, Prince wrote:

Hi Ms-Exl-Learner,

Yes dear,  you are right. There are so many ways to do the same thing. 
And thanks alot for your kind information :)


Regards
Prince

On Wednesday, December 26, 2012 12:48:10 PM UTC+5:30, Ms-Exl-Learner 
wrote:


@Prince,

Why not just added another "m" in your text function
*TEXT(C16:C35,"mmm")* which will avoid unnecessary MID Function. 
One more thing I don't think you need any case sensitivity

function here (Proper in your formula).

(TEXT(C16:C35,"mmm")=MID(PROPER(B2),1,3))*1)

TEXT(C16:C35,"mmm") = This one is text output
MID(PROPER(B2),1,3))*1 = What is the purpose of *1 in this???

Does it make any sense?

On Wed, Dec 26, 2012 at 12:22 PM, Prince > wrote:

Hi Rajesh,

It may help you,.

=SUM((D16:D35)*(TEXT(C16:C35,"mmm")=MID(PROPER(B2),1,3))*1)
with cse

Regards
Prince


On Wednesday, December 26, 2012 11:24:19 AM UTC+5:30, kasper
wrote:

Hi Experts,

In the attachment file the sumif formula is not working I
don't know
why.kindly point the mistakes in it.

Regards

Rajesh

-- 
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-...@googlegroups.com .
To unsubscribe from this group, send email to
excel-macros...@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.




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

Re: $$Excel-Macros$$ Re: Sumif not working

2012-12-26 Thread Prince 
Hi Ms-Exl-Learner,

Yes dear,  you are right. There are so many ways to do the same thing. And 
thanks alot for your kind information :)

Regards
Prince

On Wednesday, December 26, 2012 12:48:10 PM UTC+5:30, Ms-Exl-Learner wrote:
>
> @Prince,
>
> Why not just added another "m" in your text function 
> *TEXT(C16:C35,"mmm")*which will avoid unnecessary MID Function.  One more 
> thing I don't think 
> you need any case sensitivity function here (Proper in your formula).
>
> (TEXT(C16:C35,"mmm")=MID(PROPER(B2),1,3))*1)
>
> TEXT(C16:C35,"mmm") = This one is text output 
> MID(PROPER(B2),1,3))*1 = What is the purpose of *1 in this???
>
> Does it make any sense?
>
> On Wed, Dec 26, 2012 at 12:22 PM, Prince 
> > wrote:
>
>> Hi Rajesh,
>>
>> It may help you,.
>>
>> =SUM((D16:D35)*(TEXT(C16:C35,"mmm")=MID(PROPER(B2),1,3))*1) with cse
>>
>> Regards
>> Prince 
>>
>>
>> On Wednesday, December 26, 2012 11:24:19 AM UTC+5:30, kasper wrote:
>>>
>>> Hi Experts, 
>>>
>>> In the attachment file the sumif formula is not working I don't know 
>>> why.kindly point the mistakes in it. 
>>>
>>> Regards 
>>>
>>> Rajesh 
>>>
>>  -- 
>> 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-...@googlegroups.com
>> .
>> To unsubscribe from this group, send email to 
>> excel-macros...@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$$ Re: Sumif not working

2012-12-25 Thread Ms-Exl-Learner . 
@Prince,

Why not just added another "m" in your text function
*TEXT(C16:C35,"mmm")*which will avoid unnecessary MID Function.  One
more thing I don't think
you need any case sensitivity function here (Proper in your formula).

(TEXT(C16:C35,"mmm")=MID(PROPER(B2),1,3))*1)

TEXT(C16:C35,"mmm") = This one is text output
MID(PROPER(B2),1,3))*1 = What is the purpose of *1 in this???

Does it make any sense?

On Wed, Dec 26, 2012 at 12:22 PM, Prince  wrote:

> Hi Rajesh,
>
> It may help you,.
>
> =SUM((D16:D35)*(TEXT(C16:C35,"mmm")=MID(PROPER(B2),1,3))*1) with cse
>
> Regards
> Prince
>
>
> On Wednesday, December 26, 2012 11:24:19 AM UTC+5:30, kasper wrote:
>>
>> Hi Experts,
>>
>> In the attachment file the sumif formula is not working I don't know
>> why.kindly point the mistakes in it.
>>
>> Regards
>>
>> Rajesh
>>
>  --
> 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$$ Re: Sumif not working

2012-12-25 Thread Ms-Exl-Learner 

@ Lalit Mohan,

You're Welcome and *accept my thanks to you* for *not taking anything in 
negative* :)


Anyone can point out my solutions too... if my suggestion goes wrong :)

On 26-12-2012 12:29 PM, Lalit Mohan Pandey wrote:

Thanks Ms-Exl-Learner for the suggestion.

Regards,
Lalit Mohan

On Wednesday, 26 December 2012 11:52:11 UTC+5:30, Ms-Exl-Learner wrote:

@Lalit,

Why not a *Non Array Formula* suggestion?
In D2 cell
=SUMPRODUCT((TEXT($B$16:$B$380,"")=$B2)*(D$16:D$380))
Drag it right

Do you think your solution will work in all systems? The answer is
*NO*.

It *FAIL* in many systems because of different date formatting in
*Regional Date&Time Setting* :(

When you are suggesting alternate solution, then be cautious about
the side effects :)


On 26-12-2012 11:49 AM, Lalit Mohan Pandey wrote:

Hi Rajesh,

Apply below formula instead of yours with Ctrl + Shift + Enter

=SUM((MONTH($C$16:$C$380)=MONTH($B2&1))*(D$16:D$380))

and the mistake is the matching range is in date format and the
criteria is in Text format.

Regards,
Lalit Mohan
+919711867226


On Wednesday, 26 December 2012 11:24:19 UTC+5:30, kasper wrote:

Hi Experts,

In the attachment file the sumif formula is not working I
don't know
why.kindly point the mistakes in it.

Regards

Rajesh

-- 
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-...@googlegroups.com
.
To unsubscribe from this group, send email to
excel-macros...@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.




--
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$$ Re: Sumif not working

2012-12-25 Thread Lalit Mohan Pandey 
Thanks Ms-Exl-Learner for the suggestion.

Regards,
Lalit Mohan

On Wednesday, 26 December 2012 11:52:11 UTC+5:30, Ms-Exl-Learner wrote:
>
>  @Lalit,
>
> Why not a *Non Array Formula* suggestion?
> In D2 cell
> =SUMPRODUCT((TEXT($B$16:$B$380,"")=$B2)*(D$16:D$380))
> Drag it right
>
> Do you think your solution will work in all systems? The answer is *NO*.
>
> It *FAIL* in many systems because of different date formatting in *Regional 
> Date&Time Setting* :(
>
> When you are suggesting alternate solution, then be cautious about the 
> side effects :)
>
>
> On 26-12-2012 11:49 AM, Lalit Mohan Pandey wrote:
>  
>  Hi Rajesh,
>
>  Apply below formula instead of yours with Ctrl + Shift + Enter
>
>  =SUM((MONTH($C$16:$C$380)=MONTH($B2&1))*(D$16:D$380))
>
>  and the mistake is the matching range is in date format and the criteria 
> is in Text format.
>
>  Regards,
> Lalit Mohan
> +919711867226
>
>  
> On Wednesday, 26 December 2012 11:24:19 UTC+5:30, kasper wrote: 
>>
>> Hi Experts, 
>>
>> In the attachment file the sumif formula is not working I don't know 
>> why.kindly point the mistakes in it. 
>>
>> Regards 
>>
>> Rajesh 
>>
>  -- 
> 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-...@googlegroups.com
> .
> To unsubscribe from this group, send email to 
> excel-macros...@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$$ Re: Sumif not working

2012-12-25 Thread Ms-Exl-Learner 

@Lalit,

Why not a *Non Array Formula* suggestion?
In D2 cell
=SUMPRODUCT((TEXT($B$16:$B$380,"")=$B2)*(D$16:D$380))
Drag it right

Do you think your solution will work in all systems? The answer is *NO*.

It *FAIL* in many systems because of different date formatting in 
*Regional Date&Time Setting* :(


When you are suggesting alternate solution, then be cautious about the 
side effects :)



On 26-12-2012 11:49 AM, Lalit Mohan Pandey wrote:

Hi Rajesh,

Apply below formula instead of yours with Ctrl + Shift + Enter

=SUM((MONTH($C$16:$C$380)=MONTH($B2&1))*(D$16:D$380))

and the mistake is the matching range is in date format and the 
criteria is in Text format.


Regards,
Lalit Mohan
+919711867226


On Wednesday, 26 December 2012 11:24:19 UTC+5:30, kasper wrote:

Hi Experts,

In the attachment file the sumif formula is not working I don't know
why.kindly point the mistakes in it.

Regards

Rajesh

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