Forum Discussion
Solved
"Complex" formula needed for a debtors ledger
Alrighty so I'm still learning my way around excel and I'm trying to make a formula that will count how many deposits have been made that are less than half of the total invoice amount. They also nee...
Hi Madeleine,
You may continue filtering with SUMPRODUCT like
=SUMPRODUCT((PaidRange<1/2DepositRange)*(JobRange=Cod)*(Salesman=Name))
or use COUNTIFS() to count with multiple criteria.
Hi Madeleine,
You may continue filtering with SUMPRODUCT like
=SUMPRODUCT((PaidRange<1/2DepositRange)*(JobRange=Cod)*(Salesman=Name))
or use COUNTIFS() to count with multiple criteria.
Thank you so much! It's worked perfectly :)