Hi Kalyan,
Looks like you need to repeat the same formula twice in the same cell.
Once with Distributor and once with Super stockist. Ya, do not forget
to adjoin the formula's with plus in between. ;)
I don't understand one thing though, why don't you use Pivot. Its
really easy with that.
Anyways, I would have attached the file but since i am replying from
the group's page, i don't know how to do it. I am pasting the formula
from 1st cell here which you can copy in cell B5.
//
=SUMIFS('Raw Data'!$D$2:$D$87439,'Raw Data'!$A$2:$A$87439,Report!
$A5,'Raw Data'!$C$2:$C$87439,Report!B$4,'Raw Data'!$B$2:$B
$87439,"Distributor")+SUMIFS('Raw Data'!$D$2:$D$87439,'Raw Data'!$A
$2:$A$87439,Report!$A5,'Raw Data'!$C$2:$C$87439,Report!B$4,'Raw Data'!
$B$2:$B$87439,"Super Stockist") //
Bye for now,
Prashant.
On Aug 19, 7:43 am, Kal xcel <kalx...@gmail.com> wrote:
> Thanks experts.
>
> But I need the sale data of "Distributor+super stockist" only. not the
> whole. I have done for one customer group="Distributor, by Sumifs function,
> but when its matter of more than one customer group......sumifs not working
> properly.
>
> Please help.
>
> Thanks in advance
>
> KalyanOn Wed, Aug 18, 2010 at 7:53 PM, ashish koul <koul.ash...@gmail.com>
> wrote:
> > check the attachment
>
> > Regards
> > ASHISH
> > akoul.blogspot.com
>
> > On Wed, Aug 18, 2010 at 6:48 PM, Kal xcel <kalx...@gmail.com> wrote:
>
> >> Dear Experts,
>
> >> I am attaching a file where I have raw data of Depot, Customer group,
> >> Month and Sales data. There are 16 types of customer group. I need depot
> >> wise month wise & Distributor+Super stockist wise(customer group) sale
> >> data.
>
> >> I tried with sumifs & sumproduct formula, but it's not working properly.
>
> >> Pivot table is not my required solution.
>
> >> Thanks in advance
>
> >> Kalyan
>
> >> --
>
> >> ----------------------------------------------------------------------------------
> >> 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 athttp://www.excel-macros.blogspot.com
> >> 4. Learn VBA Macros athttp://www.quickvba.blogspot.com
> >> 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com
>
> >> To post to this group, send email to excel-macros@googlegroups.com
>
> >> <><><><><><><><><><><><><><><><><><><><><><>
> >> HELP US GROW !!
>
> >> We reach over 7000 subscribers worldwide and receive many nice notes about
> >> the learning and support from the group.Let friends and co-workers know
> >> they
> >> can subscribe to group at
> >>http://groups.google.com/group/excel-macros/subscribe
--
----------------------------------------------------------------------------------
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
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!
We reach over 7000 subscribers worldwide and receive many nice notes about the
learning and support from the group.Let friends and co-workers know they can
subscribe to group at http://groups.google.com/group/excel-macros/subscribe
