Re: $$Excel-Macros$$ problem in sumif
Hi Rajesh,
You are welcome!
---
Ms.Exl.Learner
---
On Sat, Dec 18, 2010 at 4:56 PM, Rajesh K R rajeshkainikk...@gmail.comwrote:
hi
Thanks for ur answer, i checked the formula , it is working well
Regards Thanks
Rajesh Kainikkara
On 12/18/10, Ms-Exl-Learner . ms.exl.lear...@gmail.com wrote:
Copy and paste the below formula:-
=SUMIF($R$8:$R$96,$A12,($X$8:$X$96))
Drag the formula cell below to the remaining cells and the criteria cell
will be getting changed and the Range and Sum Range will remains same.
But past the above formula other than R8:R96, X8:X96 range and A12 cell.
Otherwise you will get circular reference error.
Hope it's clear to you!
---
Ms.Exl.Learner
---
On Thu, Dec 16, 2010 at 4:08 PM, Rajesh K R
rajeshkainikk...@gmail.comwrote:
hi
Thanks 4 ur reply,it was a sample what i required, in the actual data
its around 300 items in it
the data will never in the order.Formula given under is giving a
correct answer in my actual database, but it have auto filling problem
=SUMIF(R8:R96,a12,(X8:X96))
=SUMIF(R8:R96,a13,(X8:X96))
=SUMIF(R8:R96,a14,(X8:X96))
i want fill down the formula in this order how can i do, in this only
criteria have to change, but the range is same for all cells
Regards
Rajesh kainikkara
On 12/15/10, Daniel dcolarde...@free.fr wrote:
Hi,
1. Formula should be (in H3 :
=SUMIF('STOCK SUMMERY'!A3:A5,REPORT!A3,DAMAGE!B2:B5)
2. The drinks in column A should be in the same order on each sheet.
Regards.
Daniel
-Message d'origine-
De : excel-macros@googlegroups.com
[mailto:excel-mac...@googlegroups.com]
De
la part de Rajesh K R
Envoyé : mercredi 15 décembre 2010 13:02
À : excel-macros
Objet : $$Excel-Macros$$ problem in sumif
Hi Experts
Pls find the attachment , tell me whats wrong in the formula
STOCK SUMMERY - 1 st sheet
OPENING PURCHASESALEBALANCE
COLA 1000 250 700 550
SODA500 100 300 300
WATER 400150 100 450
DAMAGE STOCK - 2 nd sheet
SODA 20
COLA 5
WATER 4
STOCK SUMMERY ADJUSTED- 3 rd sheet
OPENING PURCHASESALEGOODDAMAGE
BALANCE
SODA 1000250 700 530
20550
COLA 500 100 300 295
5 300
WATER 400 150 100 446
4 450
SUMIF('STOCK SUMMERY'!A3:A5,REPORT!A3:A5,(DAMAGE!B2:B5))
I tried the above formula in the column damage in 3 rd sheet , but it
shown
only wrong values, kindly tell me how correct the formula.
Regards
Rajesh kainikkara
--
--
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/pages/discussexcelcom/160307843985936?v=wallref=ts
--
--
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/pages/discussexcelcom/160307843985936?v=wallref=ts
--
--
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/pages/discussexcelcom/160307843985936?v=wallref=ts
Re: $$Excel-Macros$$ problem in sumif
Copy and paste the below formula:-
=SUMIF($R$8:$R$96,$A12,($X$8:$X$96))
Drag the formula cell below to the remaining cells and the criteria cell
will be getting changed and the Range and Sum Range will remains same.
But past the above formula other than R8:R96, X8:X96 range and A12 cell.
Otherwise you will get circular reference error.
Hope it's clear to you!
---
Ms.Exl.Learner
---
On Thu, Dec 16, 2010 at 4:08 PM, Rajesh K R rajeshkainikk...@gmail.comwrote:
hi
Thanks 4 ur reply,it was a sample what i required, in the actual data
its around 300 items in it
the data will never in the order.Formula given under is giving a
correct answer in my actual database, but it have auto filling problem
=SUMIF(R8:R96,a12,(X8:X96))
=SUMIF(R8:R96,a13,(X8:X96))
=SUMIF(R8:R96,a14,(X8:X96))
i want fill down the formula in this order how can i do, in this only
criteria have to change, but the range is same for all cells
Regards
Rajesh kainikkara
On 12/15/10, Daniel dcolarde...@free.fr wrote:
Hi,
1. Formula should be (in H3 :
=SUMIF('STOCK SUMMERY'!A3:A5,REPORT!A3,DAMAGE!B2:B5)
2. The drinks in column A should be in the same order on each sheet.
Regards.
Daniel
-Message d'origine-
De : excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
De
la part de Rajesh K R
Envoyé : mercredi 15 décembre 2010 13:02
À : excel-macros
Objet : $$Excel-Macros$$ problem in sumif
Hi Experts
Pls find the attachment , tell me whats wrong in the formula
STOCK SUMMERY - 1 st sheet
OPENING PURCHASESALEBALANCE
COLA 1000 250 700 550
SODA500 100 300 300
WATER 400150 100 450
DAMAGE STOCK - 2 nd sheet
SODA 20
COLA 5
WATER 4
STOCK SUMMERY ADJUSTED- 3 rd sheet
OPENING PURCHASESALEGOODDAMAGE
BALANCE
SODA 1000250 700 530
20550
COLA 500 100 300 295
5 300
WATER 400 150 100 446
4 450
SUMIF('STOCK SUMMERY'!A3:A5,REPORT!A3:A5,(DAMAGE!B2:B5))
I tried the above formula in the column damage in 3 rd sheet , but it
shown
only wrong values, kindly tell me how correct the formula.
Regards
Rajesh kainikkara
--
--
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/pages/discussexcelcom/160307843985936?v=wallref=ts
--
--
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/pages/discussexcelcom/160307843985936?v=wallref=ts
--
--
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/pages/discussexcelcom/160307843985936?v=wallref=ts
--
--
--
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
Re: $$Excel-Macros$$ problem in sumif
hi
Thanks 4 ur reply,it was a sample what i required, in the actual data
its around 300 items in it
the data will never in the order.Formula given under is giving a
correct answer in my actual database, but it have auto filling problem
=SUMIF(R8:R96,a12,(X8:X96))
=SUMIF(R8:R96,a13,(X8:X96))
=SUMIF(R8:R96,a14,(X8:X96))
i want fill down the formula in this order how can i do, in this only
criteria have to change, but the range is same for all cells
Regards
Rajesh kainikkara
On 12/15/10, Daniel dcolarde...@free.fr wrote:
Hi,
1. Formula should be (in H3 :
=SUMIF('STOCK SUMMERY'!A3:A5,REPORT!A3,DAMAGE!B2:B5)
2. The drinks in column A should be in the same order on each sheet.
Regards.
Daniel
-Message d'origine-
De : excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] De
la part de Rajesh K R
Envoyé : mercredi 15 décembre 2010 13:02
À : excel-macros
Objet : $$Excel-Macros$$ problem in sumif
Hi Experts
Pls find the attachment , tell me whats wrong in the formula
STOCK SUMMERY - 1 st sheet
OPENING PURCHASESALEBALANCE
COLA 1000 250 700 550
SODA500 100 300 300
WATER 400150 100 450
DAMAGE STOCK - 2 nd sheet
SODA 20
COLA 5
WATER 4
STOCK SUMMERY ADJUSTED- 3 rd sheet
OPENING PURCHASESALEGOODDAMAGE
BALANCE
SODA 1000250 700 530
20550
COLA 500 100 300 295
5 300
WATER 400 150 100 446
4 450
SUMIF('STOCK SUMMERY'!A3:A5,REPORT!A3:A5,(DAMAGE!B2:B5))
I tried the above formula in the column damage in 3 rd sheet , but it shown
only wrong values, kindly tell me how correct the formula.
Regards
Rajesh kainikkara
--
--
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/pages/discussexcelcom/160307843985936?v=wallref=ts
--
--
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/pages/discussexcelcom/160307843985936?v=wallref=ts
--
--
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/pages/discussexcelcom/160307843985936?v=wallref=ts
RE: $$Excel-Macros$$ problem in sumif
Hi,
1. Formula should be (in H3 :
=SUMIF('STOCK SUMMERY'!A3:A5,REPORT!A3,DAMAGE!B2:B5)
2. The drinks in column A should be in the same order on each sheet.
Regards.
Daniel
-Message d'origine-
De : excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] De
la part de Rajesh K R
Envoyé : mercredi 15 décembre 2010 13:02
À : excel-macros
Objet : $$Excel-Macros$$ problem in sumif
Hi Experts
Pls find the attachment , tell me whats wrong in the formula
STOCK SUMMERY - 1 st sheet
OPENING PURCHASESALEBALANCE
COLA 1000 250 700 550
SODA500100 300 300
WATER 400 150 100 450
DAMAGE STOCK - 2 nd sheet
SODA20
COLA5
WATER 4
STOCK SUMMERY ADJUSTED - 3 rd sheet
OPENING PURCHASESALEGOODDAMAGE
BALANCE
SODA 1000250 700 530
20 550
COLA 500 100 300 295
5 300
WATER400 150 100 446
4 450
SUMIF('STOCK SUMMERY'!A3:A5,REPORT!A3:A5,(DAMAGE!B2:B5))
I tried the above formula in the column damage in 3 rd sheet , but it shown
only wrong values, kindly tell me how correct the formula.
Regards
Rajesh kainikkara
--
--
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/pages/discussexcelcom/160307843985936?v=wallref=ts
--
--
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/pages/discussexcelcom/160307843985936?v=wallref=ts
