Formula with multiple criteria

  • Thread starter Thread starter Rick
  • Start date Start date
R

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
 
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))
 
Back
Top