جرجير افندى قام بنشر مارس 31, 2020 مشاركة قام بنشر مارس 31, 2020 How can be short =IFERROR(SUMIFS(INDIRECT("'"&$P$2&"'!"&"p11:p40000"),INDIRECT("'"&$P$2&"'!"&"d11:d40000"),$D$11,INDIRECT("'"&$P$2&"'!"&"n11:n40000"),[@[Account_code]],INDIRECT("'"&$P$2&"'!"&"k11:k40000"),[@Parid],INDIRECT("'"&$P$2&"'!"&"l11:l40000"),[@Year]),0)+IFERROR(SUMIFS(INDIRECT("'"&$Z$2&"'!"&"p11:p40000"),INDIRECT("'"&$Z$2&"'!"&"d11:d40000"),$D$11,INDIRECT("'"&$Z$2&"'!"&"n11:n40000"),[@[Account_code]],INDIRECT("'"&$Z$2&"'!"&"k11:k40000"),[@Parid],INDIRECT("'"&$Z$2&"'!"&"l11:l40000"),[@Year]),0)+IFERROR(SUMIFS(INDIRECT("'"&$Q$2&"'!"&"p11:p40000"),INDIRECT("'"&$Q$2&"'!"&"d11:d40000"),$D$11,INDIRECT("'"&$Q$2&"'!"&"n11:n40000"),[@[Account_code]],INDIRECT("'"&$Q$2&"'!"&"k11:k40000"),[@Parid],INDIRECT("'"&$Q$2&"'!"&"l11:l40000"),[@Year]),0)+IFERROR(SUMIFS(INDIRECT("'"&$R$2&"'!"&"p11:p40000"),INDIRECT("'"&$R$2&"'!"&"d11:d40000"),$D$11,INDIRECT("'"&$R$2&"'!"&"n11:n40000"),[@[Account_code]],INDIRECT("'"&$R$2&"'!"&"k11:k40000"),[@Parid],INDIRECT("'"&$R$2&"'!"&"l11:l40000"),[@Year]),0)+IFERROR(SUMIFS(INDIRECT("'"&$S$2&"'!"&"p11:p40000"),INDIRECT("'"&$S$2&"'!"&"d11:d40000"),$D$11,INDIRECT("'"&$S$2&"'!"&"n11:n40000"),[@[Account_code]],INDIRECT("'"&$S$2&"'!"&"k11:k40000"),[@Parid],INDIRECT("'"&$S$2&"'!"&"l11:l40000"),[@Year]),0)+IFERROR(SUMIFS(INDIRECT("'"&$T$2&"'!"&"p11:p40000"),INDIRECT("'"&$T$2&"'!"&"d11:d40000"),$D$11,INDIRECT("'"&$T$2&"'!"&"n11:n40000"),[@[Account_code]],INDIRECT("'"&$T$2&"'!"&"k11:k40000"),[@Parid],INDIRECT("'"&$T$2&"'!"&"l11:l40000"),[@Year]),0)+IFERROR(SUMIFS(INDIRECT("'"&$U$2&"'!"&"p11:p40000"),INDIRECT("'"&$U$2&"'!"&"d11:d40000"),$D$11,INDIRECT("'"&$U$2&"'!"&"n11:n40000"),[@[Account_code]],INDIRECT("'"&$U$2&"'!"&"k11:k40000"),[@Parid],INDIRECT("'"&$U$2&"'!"&"l11:l40000"),[@Year]),0)+IFERROR(SUMIFS(INDIRECT("'"&$V$2&"'!"&"p11:p40000"),INDIRECT("'"&$V$2&"'!"&"d11:d40000"),$D$11,INDIRECT("'"&$V$2&"'!"&"n11:n40000"),[@[Account_code]],INDIRECT("'"&$V$2&"'!"&"k11:k40000"),[@Parid],INDIRECT("'"&$V$2&"'!"&"l11:l40000"),[@Year]),0)+IFERROR(SUMIFS(INDIRECT("'"&$W$2&"'!"&"p11:p40000"),INDIRECT("'"&$W$2&"'!"&"d11:d40000"),$D$11,INDIRECT("'"&$W$2&"'!"&"n11:n40000"),[@[Account_code]],INDIRECT("'"&$W$2&"'!"&"k11:k40000"),[@Parid],INDIRECT("'"&$W$2&"'!"&"l11:l40000"),[@Year]),0)+IFERROR(SUMIFS(INDIRECT("'"&$X$2&"'!"&"p11:p40000"),INDIRECT("'"&$X$2&"'!"&"d11:d40000"),$D$11,INDIRECT("'"&$X$2&"'!"&"n11:n40000"),[@[Account_code]],INDIRECT("'"&$X$2&"'!"&"k11:k40000"),[@Parid],INDIRECT("'"&$X$2&"'!"&"l11:l40000"),[@Year]),0)+IFERROR(SUMIFS(INDIRECT("'"&$Y$2&"'!"&"p11:p40000"),INDIRECT("'"&$Y$2&"'!"&"d11:d40000"),$D$11,INDIRECT("'"&$Y$2&"'!"&"n11 :n40000"),[@[Account_code]],INDIRECT("'"&$Y$2&"'!"&"k11:k40000"),[@Parid],INDIRECT("'"&$Y$2&"'!"&"l11:l40000"),[@Year]),0) عليك برفع ملف موضح عليه المطلوب بكل دقة.... والا ستحذف المشاركة بناءاً على قوانين وتعليمات المنتدى رابط هذا التعليق شارك More sharing options...
مهند محسن قام بنشر مارس 31, 2020 مشاركة قام بنشر مارس 31, 2020 اده يعنى ايه ؟!! وهل يعقل ان تنتظر المساعدة من احد بهذه الطريقة ؟!!!! لابد من رفع ملف مدعوم بشرح كافى عن المطلوب رابط هذا التعليق شارك More sharing options...
الردود الموصى بها
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.