Yu can use that convention if you're willing to use an array formula

e.g. this works. You'd have to change names etc.

~=SUM((DOSDEP=$B19)*(DOS_Acct =$C19)*(DOS_Acct <=
$D19)*(MONTH(DOS)=MONTH($G$3))*(DOSAmount))

Here I'm looking up both the month of the range month and the column
header.

Siegfried

Ctrl-Shift-Enter