Forum Discussion

John Cotton's avatar
John Cotton
Copper Contributor
Mar 27, 2018
Solved

Help with a table

Hi everyone, I'm new to the community and am looking for some help with a table I'm trying to put together. I need a spread sheet to calculate the charges for investments at different levels. The...
  • Jamil's avatar
    Jamil
    Mar 27, 2018

    Hello John,

     

    I misunderstood your question. Now, I get it ;-)

     

    What you need is a simple table with helper column and SUMPRODUCT  Function.

     

    Formula in F3 is =SUMPRODUCT(--($F$2>$A$2:$A$6),--($F$2-$A$2:$A$6),$D$2:$D$6)

     

Resources