Hi, I'm a bit rusty with this formula, which i have entered as an array and
have forgotten what i have done wrong;

My formula =IF('Purchase Ledger'!F:F=Creditors!B5,SUMIF('Purchase
Ledger'!D:D,Creditors!D3,'Purchase Ledger'!H:H),"")
has a problem with the first argument to check if the entries in column F of
the Purchase ledger is a match for the row in Creditors. I have created a
data list to ensure the spelling etc is correct so only identical names can
be displayed in the two spreadsheets. If there is a match then it checks the
month number and if that corresponds (Creditors!D3) then it totals all the
entries in the column that match.
How can i resolve the problem please?
TIA
Chris