Hi,
I'm a novice excel user having a problem in obtains monthly totals, using a Sumproduct array, as I keep getting a #Value! error.
The CSE code is:
{=SUMPRODUCT("(MONTH($Master!$A$3:$A$54)=7)*(YEAR($Master!$A$3:$A$54)=2019)*Master!$E$3:$E$54)")}
Where columns in a Master sheet are:-
A=Date
(entered randomly using either (/) or (.) separators and with d or dd or m or mm and yy or yyyy but formatted by using SHORT DATE to display uniformly, eg: 31/12/2019
B=PurchaserID
C=RefID
D=SupplierID
E=Item amount
The code is in a cell on a separate sheet.
Can anyone help?
Cheers, H.
Bookmarks