Formula to choose visible cells only

[AdriJW]

Hi,

I have a Table of information in cells F2:P1259; there is data in columns F-L and values regarding the data in columns M-P. I need a formula that chooses the visible cells in column M when I filter in columns F-L.

I have a percentage number in cell L1261 that I need to multiply with whatever number comes visible in column N when I filter in columns F-L.

Is there any formula that does this? Thank you so much!!!

 

[Eric W]

Welcome to the forum.

I'm a little confused. After you filter your table, you'll have 0-n visible rows. And you want to take the sum of the visible cells in column M (or is it N), and multiply by L1261?

If so, try:

=SUBTOTAL(109,M2:M1259)*L1261