My formula in excel will not work

Can someone look at the excel example that I downloaded, and tell me what I did wrong? The yellow high-lighted is what I am wanting to accomplish and the light-blue is what I am getting with the formulas I created and am stumped as to what I am doing wrong?
The first part  -- IF(ROWS($F$6:$F6)>COUNTIF(Amount,">0"), -- is working fine but the Index fuction  --  INDEX($A$6:$A$19,SMALL(IF(Amount>0,ROW(Amount)-ROW(D$6)+1),ROWS(F$6:F6))) -- is not working.

In this example, 7 names have amounts in the amount column, and if another name (for instance Susie) would have an amount that needs to dynamically show also.
learning.xlsx
beemmerAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
NBVCConnect With a Mentor Commented:
The formula in F6 is an Array formula.  You need to confirm it with CTRL+SHIFT+ENTER not just ENTER so that you see { } brackets appear around the formula... then you can copy it down.

Also to get rid of the #N/A in the VLOOKUP columns, add an IFERROR()

e.g. in G6:

=IFERROR(VLOOKUP($F6,$A$6:$D$19,2,FALSE),"")

copied down
0
 
beemmerAuthor Commented:
Thank you so much for your help.  Your solution worked beautifully.  I would not have figured that out on my own.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.