Formula with multiple criteria

[Rick]

I need a total in column "Q" that is calculated on the
following:

If the "date" in column "A" is January ??, and
the "number of days to pay" in column "K" is greater than
or equal to "0", but less than or equal to "29", I need
the "amount paid" in column "L" to total in column "Q"

I am really having trouble with the part of the formula
that calls out - "between 0 and 29"

Thank you, Rick

 

[Arvi Laanemets]

Hi

With data in rows 2-100
=SUMPRODUCT((MONTH($A$2:$A$100=1)*($K$2:$K$100>=0)*($K$2:$K$100<=29)*($L$2:$
L$100))