Need forumula to get value of cell if another cell is >0

  • Thread starter Thread starter Loren
  • Start date Start date
L

Loren

Hi all,
I have a spreadsheet with names in A6:A20. There are % in
B6:B20. In cells A40:A54, I want to list the names in
A6:A20 where the value of B6:B20 is greater than 0.

Can anybody show me how to do this?

Thanks in advance.
 
Back
Top