I am getting an error with this formula:
D3:D628 = Finance Manager
AH3:AH628 = Sold Month
AG2 = month
R3:R628 = Finance company not equal to "zero"
{=SUM((Finance!$D$3:$D$628=Admin!$D2)*(Finance!$AH$3:$AH$628=Finance!$AG$2)*(Finance!$R$3:$R$628<>"Cash")*(Finance!$O$3:$O$628))}
Solved by M. W. in 14 mins