A clever way to do a 3D AND lookup.
Due to the limitations of this unconventional use, you have to add
some cells to your sheets.
Add a cell named POMonth
=MONTH(PO_Date)
to each 001:013 sheet
and create a 14 cell vertical vector on one sheet, named Multi.
={1;0;0;0;0;0;0;0;0;0;0;0;0;0}
The formula now is
SUMPRODUCT(SUMIF(INDIRECT("'"&TEXT(ROW(INDIRECT("1 :13")),"000")&"'!
PO_GLCode"),
$B55,INDIRECT("'"&TEXT(ROW(INDIRECT("1:13")),"000" )&"'!UnitTotal"))*
SUMIF(INDIRECT("'"&TEXT(ROW(INDIRECT("1:13")),"000 ")&"'!POMonth"),C
$8,Multi))
If you want me to send the file to a downloadable site, please give me
instructions.