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 1
Hey Kal xcel,
please clear what you want
On Thu, Jul 28, 2011 at 1:03 PM, Kal xcel kalx...@gmail.com 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
=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 kalx...@gmail.com wrote:
Dear Experts,
I have three types of customer group Distributor, Super
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