hello everyone from Egypt
kindly i need your support and help to Make the function shorter and easier , below function working good but i believe that other way to be more easier
"&"l11:l20000"),$E$5,INDIRECT("'"&$E$2&"'!"&"n11:n20000"),B7),0)
+IF(T$8="feb",SUMIFS(INDIRECT("'"&$E$2&"'!"&"q11:q20000"),INDIRECT("'"&$E$2&"'!"&"b11:b20000"),$E$2,INDIRECT("'"&$E$2&"'!"&"k11:k20000"),$E$6,INDIRECT("'"&$E$2&"'!"&"l11:l20000"),$E$5,INDIRECT("'"&$E$2&"'!"&"n11:n20000"),B7),0)
+IF(T$9="Mar",SUMIFS(INDIRECT("'"&$E$2&"'!"&"P11:P20000"),INDIRECT("'"&$E$2&"'!"&"b11:b20000"),$E$2,INDIRECT("'"&$E$2&"'!"&"k11:k20000"),$E$6,INDIRECT("'"&$E$2&"'!"&"l11:l20000"),$E$5,INDIRECT("'"&$E$2&"'!"&"n11:n20000"),B7),0)
+IF(T$10="Apr",SUMIFS(INDIRECT("'"&$E$2&"'!"&"q11:q20000"),INDIRECT("'"&$E$2&"'!"&"b11:b20000"),$E$2,INDIRECT("'"&$E$2&"'!"&"k11:k20000"),$E$6,INDIRECT("'"&$E$2&"'!"&"l11:l20000"),$E$5,INDIRECT("'"&$E$2&"'!"&"n11:n20000"),B7),0)
+IF(T$11="May",SUMIFS(INDIRECT("'"&$E$2&"'!"&"P11:P20000"),INDIRECT("'"&$E$2&"'!"&"b11:b20000"),$E$2,INDIRECT("'"&$E$2&"'!"&"k11:k20000"),$E$6,INDIRECT("'"&$E$2&"'!"&"l11:l20000"),$E$5,INDIRECT("'"&$E$2&"'!"&"n11:n20000"),B7),0)
+IF(T$12="Jun",SUMIFS(INDIRECT("'"&$E$2&"'!"&"q11:q20000"),INDIRECT("'"&$E$2&"'!"&"b11:b20000"),$E$2,INDIRECT("'"&$E$2&"'!"&"k11:k20000"),$E$6,INDIRECT("'"&$E$2&"'!"&"l11:l20000"),$E$5,INDIRECT("'"&$E$2&"'!"&"n11:n20000"),B7),0)
+IF(T$13="Jul",SUMIFS(INDIRECT("'"&$E$2&"'!"&"P11:P20000"),INDIRECT("'"&$E$2&"'!"&"b11:b20000"),$E$2,INDIRECT("'"&$E$2&"'!"&"k11:k20000"),$E$6,INDIRECT("'"&$E$2&"'!"&"l11:l20000"),$E$5,INDIRECT("'"&$E$2&"'!"&"n11:n20000"),B7),0)
+IF(T$14="Aug",SUMIFS(INDIRECT("'"&$E$2&"'!"&"q11:q20000"),INDIRECT("'"&$E$2&"'!"&"b11:b20000"),$E$2,INDIRECT("'"&$E$2&"'!"&"k11:k20000"),$E$6,INDIRECT("'"&$E$2&"'!"&"l11:l20000"),$E$5,INDIRECT("'"&$E$2&"'!"&"n11:n20000"),B7),0)
+IF(T$15="Sep",SUMIFS(INDIRECT("'"&$E$2&"'!"&"P11:P20000"),INDIRECT("'"&$E$2&"'!"&"b11:b20000"),$E$2,INDIRECT("'"&$E$2&"'!"&"k11:k20000"),$E$6,INDIRECT("'"&$E$2&"'!"&"l11:l20000"),$E$5,INDIRECT("'"&$E$2&"'!"&"n11:n20000"),B7),0)
+IF(T$16="Oct",SUMIFS(INDIRECT("'"&$E$2&"'!"&"q11:q20000"),INDIRECT("'"&$E$2&"'!"&"b11:b20000"),$E$2,INDIRECT("'"&$E$2&"'!"&"k11:k20000"),$E$6,INDIRECT("'"&$E$2&"'!"&"l11:l20000"),$E$5,INDIRECT("'"&$E$2&"'!"&"n11:n20000"),B7),0)
+IF(T$17="nov",SUMIFS(INDIRECT("'"&$E$2&"'!"&"P11:P20000"),INDIRECT("'"&$E$2&"'!"&"b11:b20000"),$E$2,INDIRECT("'"&$E$2&"'!"&"k11:k20000"),$E$6,INDIRECT("'"&$E$2&"'!"&"l11:l20000"),$E$5,INDIRECT("'"&$E$2&"'!"&"n11:n20000"),B7),0)
+IF(T$18="Dec",SUMIFS(INDIRECT("'"&$E$2&"'!"&"q11:q20000"),INDIRECT("'"&$E$2&"'!"&"b11:b20000"),$E$2,INDIRECT("'"&$E$2&"'!"&"k11:k20000"),$E$6,INDIRECT("'"&$E$2&"'!"&"l11:l20000"),$E$5,INDIRECT("'"&$E$2&"'!"&"n11:n20000"),B7),0)
Bookmarks