Code: Select all
=SUMIFS(tblOrderData!$G$5:$G$1048576, tblOrderData!$F$5:$F$1048576, $C11, tblOrderData!$A$5:$A$1048576, DATE($AH$9, MATCH($AA$9, {"January","February","March","April","May","June","July","August","September","October","November","December"}, 0), D$10))
Code: Select all
=COUNTIFS(tblMemoDetails!$N:$N,"Female",tblMemoDetails!$K:$K,DATEVALUE(D$10&"-"&$AA$9&"-"&$AH$9),tblMemoDetails!$I:$I,$C98)
Code: Select all
=SUMIFS(tblOrderData!$G:$G, tblOrderData!$J:$J,"Male",tblOrderData!$A:$A,DATEVALUE(D$10&"-"&$AA$9&"-"&$AH$9), tblOrderData!$I:$I,$C107)
Any help on this would be kindly appreciated.
Thanks in advance.
Note: both the workbooks reside in the same folder E:\My Folder System