Hey Kal xcel,
please clear what you want
On Thu, Jul 28, 2011 at 1:03 PM, Kal xcel wrote:
> Dear Haseeb,
>
> Thanks for your reply. But result is not coming with this formula.
>
> Thanks once again.
>
> Kalyan Chattopadhyay
>
> On Thu, Jul 28, 2011 at 12:21 AM, Haseeb Avarakkan <
> haseeb.a
Dear Haseeb,
Thanks for your reply. But result is not coming with this formula.
Thanks once again.
Kalyan Chattopadhyay
On Thu, Jul 28, 2011 at 12:21 AM, Haseeb Avarakkan <
haseeb.avarak...@gmail.com> wrote:
> Hello Kalyan,
>
> If you just have two customers, you can hard coded as array & use
Hello Kalyan,
If you just have two customers, you can hard coded as array & use 1 SUMIFS
with SUM.
Without checking MOC in B3
=SUM(SUMIFS('Raw data'!D:D,'Raw data'!A:A,$B5,'Raw
data'!C:C,{"Distributor","Super stockist"}))
With MOC in B3,
=SUM(SUMIFS('Raw data'!D:D,'Raw data'!A:A,$B5,'Raw dat
Thanks a lot Ashish
On Wed, Jul 27, 2011 at 1:14 PM, ashish koul wrote:
> =SUMIFS('Raw data'!D:D,'Raw data'!A:A,Query!B5,'Raw
> data'!C:C,"Distributor")+SUMIFS('Raw data'!D:D,'Raw data'!A:A,Query!B5,'Raw
> data'!C:C,"Super Stockist")
>
>
> On Wed, Jul 27, 2011 at 11:53 AM, Kal xcel wrote:
>
>>
=SUMIFS('Raw data'!D:D,'Raw data'!A:A,Query!B5,'Raw
data'!C:C,"Distributor")+SUMIFS('Raw data'!D:D,'Raw data'!A:A,Query!B5,'Raw
data'!C:C,"Super Stockist")
On Wed, Jul 27, 2011 at 11:53 AM, Kal xcel wrote:
> Dear Experts,
>
> I have three types of customer group Distributor, Super stokist & Kol