Hi Rajesh
PFA,
Regards
Prince
On Tuesday, November 20, 2012 9:55:49 PM UTC+5:30, rajeyssh wrote:
>
> Hello Every one. Please find the attachment.
> rgds
>
> --
> *Rajesh Kumar Agarwal*
> *9811063001*
>
>
--
Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
*Hello Prince*
*
*
*This is also working fine with a small changes in the cell's address as
follows :-*
*
*
in Column C
=A2&B2drag it up to* C11*
in Column D
=COUNTIF($C$2:$C2,C2) Drag it up to *D11*
Now in Cell *B12* I Wrote : =SUM((B2:B11)*(D2:D11=1)) with Ctrl+Shift+Enter
*
*
*Thank you.*
*
Hi Pravin,
Pls Note below steps what I did.
in Column C
=A2&B2drag it up to C10
in Column D
=COUNTIF($C$2:$C2,C2) Drag it up to D10
Now in Cell B11 I Wrote : =SUM((B2:B11)*(D2:D11=1)) with Ctrl+Shift+Enter
Regards
Prince
On Wednesday, October 3, 2012 10:38:03 AM UTC+5:30, Pravin Gunjal w
No problem Dave. . !! :)
Thx for your kind evaluation.
warmest regards,
Dilipandey
On 7/1/10, Dave Bonallack wrote:
>
> Hi Dilip,
>
> Sorry, didn't see your latest solution. Excellent!
>
> Regards - Dave
>
>
>
> Date: Tue, 29 Jun 2010 15:21:56 +0530
>
Hi Dilip,
Sorry, didn't see your latest solution. Excellent!
Regards - Dave
Date: Tue, 29 Jun 2010 15:21:56 +0530
Subject: $$Excel-Macros$$ Re: Required Formula
From: dilipan...@gmail.com
To: ahmedhon...@gmail.com
CC: excel-macros@googlegroups.com
Hi Ahmed,
As promised, please
will have to be replaced with something else, but
> I'm a bit too jet-lagged to think what it should be.
>
> Regards - Dave.
>
>
>
> Date: Mon, 28 Jun 2010 16:23:22 +0300
> Subject: $$Excel-Macros$$ Re: Required Formula
> From: ahmedhon...@gmail.com
> To: dilipa
something else, but I'm a
bit too jet-lagged to think what it should be.
Regards - Dave.
Date: Mon, 28 Jun 2010 16:23:22 +0300
Subject: $$Excel-Macros$$ Re: Required Formula
From: ahmedhon...@gmail.com
To: dilipan...@gmail.com
CC: excel-macros@googlegroups.com
Dear Dilip bhai,
Your
Will check and revert..!!
--
Thanks & Regards,
DILIP KUMAR PANDEY
MBA-HR,B.Com(Hons),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 62, India
On Mon, Jun 28, 2010 at 6:53 PM, Ahmedhonest wrote:
> Dear Dilip bhai,
>
>
>
> Your Formula is cool but still the
Hi Ahmed,
I am using Excel 2003 and the pivot is not showing up for me (Actually
the data part is missing). It will be useful for members like me if
you can present your desired output without pivot, so that we can have
a look.
--
Thanks & Regards,
DILIP KUMAR PANDEY
MBA-HR,B.Com(Hons),BCA
M
cel-Macros$$ Re: Required Formula
Here's a function (TotalFee) that does what you describe. Take a look
at the attached file.
Tom
On Thu, Dec 4, 2008 at 6:26 AM, Ahmedhonest <[EMAIL PROTECTED]>
wrote:
Please find the attach file and suggest your va
Hi you all Cool Guys,
Felt happy to see answers from many of you and got the enough result as i
was expecting.
A Special Thanks to Manoj S Negi & Lohith
Regards
Ahmedhonest
On Fri, Dec 5, 2008 at 2:46 PM, Manoj S Negi <
[EMAIL PROTECTED]> wrote:
> Hi Dude,
> Please find the attached file.
Hi
You can try this Formula
=SUMIF(B2:B13, "<>", D2:D13)
Regards
Krupesh
On 12/5/08, lohith <[EMAIL PROTECTED]> wrote:
>
>
> Hi,
>
> Try these Array Formulas for Text, Numeric and AlphaNumeric
>
> For Text & Alphanumeric
>
> 1) =SUM(IF(ISTEXT(A2:A13)=TRUE,D2:D13,0))
>
> For Numeric Column
>
>
Here's a function (TotalFee) that does what you describe. Take a look at
the attached file.
Tom
On Thu, Dec 4, 2008 at 6:26 AM, Ahmedhonest <[EMAIL PROTECTED]> wrote:
> Please find the attach file and suggest your valuable answers
>
> Expecting for a faster reply
>
> --
> Ahmed Bawazir
>
>
> >
Hi Dude,
Please find the attached file. May be it will useful for you.
Acknowledge the same by return mail.
*Unfeigned Regards
Manoj S Negi
**"Miles & miles to go before I sleep"
¨`·.·´¨) Always
`·.¸(¨`·.·´¨) Keep
(¨`·.·´¨)¸.·´ Smiling!
`·.¸.·´
(¨`·.·´¨) (¨`·.·´¨)
`·.¸(¨`·.·´¨)¸.·´
`·.¸.·«*:·
Hi,
Try these Array Formulas for Text, Numeric and AlphaNumeric
For Text & Alphanumeric
1) =SUM(IF(ISTEXT(A2:A13)=TRUE,D2:D13,0))
For Numeric Column
2) =SUM(IF(ISNUMBER(A2:A13)=TRUE,D2:D13,0))
Remember you need to add this formula using Ctrl+Shift+Enter.
Cheers,
Lohith
On Dec 4, 4:26 pm, A
Hi,
Try these Array Formulas for Text, Numeric and AlphaNumeric
For Text & Alphanumeric
1) =SUM(IF(ISTEXT(A2:A13)=TRUE,D2:D13,0))
For Numeric Column
2) =SUM(IF(ISNUMBER(A2:A13)=TRUE,D2:D13,0))
Remember you need to add this formula using Ctrl+Shift+Enter.
Cheers,
Lohith
On Dec 4, 4:26 pm, A
16 matches
Mail list logo
