Sumproduct question?

  • Thread starter Thread starter wahur
  • Start date Start date
W

wahur

I have following columns
A has due dates
B has actual payment date (if not paid, it would be blank)
C is amount

Now can I get somehow a sum of late payments, i.e sum of rows where
B>A? Note that most probably I will need to add more conditions (e.g
due date would have to be compared to today() in case B is blank), so
if it can be done at all then its SUMPRODUCT job most probably.
 
=SUM(IF(B2:B20="",IF(A2:A20<TODAY(),C2:C20),IF(A2:A20<B2:B20,C2:C20)))

which is an array formula, it should be committed with Ctrl-Shift-Enter, not
just Enter.

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)
 
You must log in or register to reply here.

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

Function Help - Forecast Date past due, adjacent cell is blank. Needto highlight the blank cell. 2
Excel Sumproduct 0
Comparison of columns using Conditional Formatting 3
Sorting amounts in columns by due dates 7
How do I change this to count days 1
Adding values for all rows in a range 6
proper formula or function 1
Nest 3 SUMPRODUCT formulas - Possible? 7

Back
Top