Need help on the formula

D

ddiicc

Hi there,
I have a set of datas as shown below :-

A B C D E
0.46% 0.3% 0.15% 0% 0.16%

I would like the formula to do a product of each column but will only do a
product of those % more than 0.

Can anyone help?
 
M

Mike H

Maybe

=PRODUCT(IF(A1:A100>0%,A1:A100,FALSE))

It's an array so enter with Ctrl+Shift+Enter.

Mike
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Use a variable in a ShapeRange.Increment 0
VBA Coding Help for Beginner 0
Need some PWA help 0
modified pivot table using a macro 2
Drop down list control value in vba 2
Compare Names in a column and create single list with adjacent vla 6
Dealing with the error: unable to filter on excel hc home school 0
How to get a value from 1 table to a 2nd. 15

Top