@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 w
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
@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*
HI Prince
Thanks for the formula
Rajesh
On Wednesday, December 26, 2012 12:22:05 PM UTC+5:30, 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
Hi Lalit
Thak you for the formula.
Rajesh
On Wednesday, December 26, 2012 11:49:40 AM UTC+5:30, 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 matchi
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
@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") = Thi
@ 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 W
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
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
@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&Tim
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:
12 matches
Mail list logo