Forum Discussion

madeleine onley's avatar
madeleine onley
Copper Contributor
Aug 01, 2017
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...
Formulas & Functions
Tutorial
  • SergeiBaklan's avatar
    SergeiBaklan
    Aug 01, 2017

    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.

     

     

SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Aug 01, 2017

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.

 

 

  • madeleine onley's avatar
    madeleine onley
    Copper Contributor
    Aug 01, 2017

    Thank you so much! It's worked perfectly :) 

Resources