Use the following formula.
=SUMIF($A$3:$A$322,$F$3:$F$16,$C$3:$C$322)
On Fri, Aug 12, 2011 at 4:49 PM, naresh v wrote:
> I Have mentioned my problem clearlyplease find attached sheet
>
>
> Regards,
> Naresh V
>
> --
>
> ---
Pdt Jan Feb March April May June July
A 0.52 0.60 0.60 0.71 0.71 0.66 0.00
B 0.72 0.72 0.71 0.86 0.96 0.81 0.77
C 3.84 4.35 4.39 3.88 4.23 4.06 3.69
D 1.16 1.49 1.49 1.49 1.67 1.92 0.00
E 1.13 1.32 1.32 1.57 1.57 1.44 0.00
F 1.14 1.29 1.29 1.29 3.12 3.18 0.00
I can to apply conditional formatting
Hi this is very good one..can u pls let me know how this formula works if
don't know how any duplicate values are there in the series...
Thanks
Jagadeesh
On Mon, Aug 1, 2011 at 5:13 PM, NOORAIN ANSARI wrote:
> Dear Jocky,
>
> Please use below formula...it wll be useful in case of duplicacy..
>
Ashish Koul
Thank you soo much for the help...
On Wed, Feb 16, 2011 at 8:31 PM, ashish koul wrote:
> check the attachment
>
> On Wed, Feb 16, 2011 at 6:19 PM, Jagadeesh B S wrote:
>
>> Hello all
>>
>>
>>
>> I have date like
>&
Ashish Koul
Its not working...:(
Regards
Jagadeesh B S
On Fri, Feb 4, 2011 at 12:15 PM, ashish koul wrote:
> HI
>
> try this see if it helps
>
> paste unique names and email ids on sheet 3
>
>
>
> On Thu, Feb 3, 2011 at 2:50 PM, Jagadeesh B S wrote:
>
>>
as attachment also
>
> r u using outlook or notes
>
> On Thu, Feb 3, 2011 at 12:16 PM, Jagadeesh B S wrote:
>
>> Hello friends.
>>
>> Can any one help me on this?
>>
>> Thanks in advance
>> Jagadeesh B S
>>
>> On Wed, Feb
Hello friends.
Can any one help me on this?
Thanks in advance
Jagadeesh B S
On Wed, Feb 2, 2011 at 5:30 PM, Jagadeesh B S wrote:
> Hello friends I am looking for solution for our intercompany company
> reconciliation report.
>
>
>
> I have data as per the sheet *dat
the regard.
Looking forward for some help.
Thanks
Jagadeesh B S
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our
Congratulations Dlip.:)
Thanks
Jagadeesh B S
On Mon, Jan 3, 2011 at 3:31 PM, Ayush wrote:
> Dear Group,
>
> I am very very very very happy to share a good news with you. One of our
> dearest group member "Dilip Kumar Pandey" is awarded Microsoft MVP award on
Ashish Koul
Could you please help me in understanding the formula and how did it...Pls
help to learn writing complex formulas.
Thanks in advance
Jagadeesh B S
On Tue, Nov 30, 2010 at 1:07 PM, ashish koul wrote:
> Check the attachment see if it helps
>
>
> On Tue, Nov 30, 2010
helping others.
*
On Tue, Nov 30, 2010 at 12:18 PM, amrahs k wrote:
> Hope this helps. Have a look at the attached workbook.
>
> On Tue, Nov 30, 2010 at 11:35 AM, Jagadeesh B S wrote:
>
>>
>> Hello Friends
>>
>> I need a formula or macro( preferabley for
Hello Friends
I need a formula or macro( preferabley formule) need to prepare this report
.
I need a formula which should get the details for the account # mentioned in
the column A with the reference to the currency,form the sheet DATA, if the
currency is USD It should pull the value in the colu
Hello all,
Could someone please help me for my requirement
Thanks in advance
Jagadeesh B S
On Fri, Nov 26, 2010 at 12:44 PM, Jagadeesh B S wrote:
> Hello all
>
> I need to prepare the reconciliation report for my company and send it to
> all the person who is responsible f
to populate the values and a macro to integrate Excel and
mailbox so that I can send it to all the people with the data highlighted in
the box above.
Please guide me to write the formulas for myself.
Thanks for looking into it and helping me.
Thanks in advance
Jagadeesh B S
9963025705
Hi all
I see there is some proble with the data only.which needs some changes to be
done.
Thank you so much for the help.
Thanks
Jagadeesh B S
On Thu, Nov 18, 2010 at 7:56 PM, Ajay Varshney
wrote:
> Problem is with the data on the Data tab.
>
>
> Almost all accounts have more
Hello Friends
I need a formula or macro( preferabley formule) need to prepare this report
.
I need a formula which should get the details for the account # mentioned in
the column A with the reference to the currency,form the sheet DATA, if the
currency is USD It should pull the value in the colu
you
Jagadeesh B S
--
--
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
Hi Kalyan pls use Pivot table u can see like the date below.
Count of BP Name - Report Depot Name BP Name - Report Total
Ahmedabad H K Sales Agency - Sanand 1 Parshwa Traders - Gandhinagar 1 Soham
Agency - Chikhli 1 Ahmedabad Total 3 Ambala Chaman Traders - Ambala 1 Happy
Traders
hi all
If i want to pull the dates also in the seond sheet how to pull that dates
pls help.
Actually i want to pul the data right side of the vlookup data.
Pls help
On Wed, May 5, 2010 at 1:41 PM, Aindril De wrote:
> Hi Dheeraj,
>
> You have done half of the work...You have sorted the data a
19 matches
Mail list logo