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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

COUNTIF....how to use >=0 but <9 as CRITERIA 3
Excel Need Countifs Formula Help 0
Excel 2002 IF 1
Conditional Formatting on Index,Match formula 3
IF statements with multiple criteria 2
Multiple logic tests 0
if formula - multi criteria 6
Countif, plus ? 8

Back
Top