Hi Rajesh,
You are welcome!
---
Ms.Exl.Learner
---
On Sat, Dec 18, 2010 at 4:56 PM, Rajesh K R wrote:
> hi
> Thanks for ur answer, i checked the formula , it is working well
>
> Regards & Thanks
> Rajesh Kainikkara
>
> On 12/18/10, Ms-Exl-Learner . wrote
hi
Thanks for ur answer, i checked the formula , it is working well
Regards & Thanks
Rajesh Kainikkara
On 12/18/10, Ms-Exl-Learner . 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
>
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.
Otherwi
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
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
