Formula to skip cells with 0 value.

[erniepoe]

Hi all,

I have a list of six columns with data (B;G). Column B is values, some of which are positive numbers, some of which are zero. Column D is dates. There are no headers on columns, but could easily add them if it would help. I would like to use a formula to construct a table of only the values in column B that are greater than 0, and only the dates in column D greater than the end of the most previous month.

I tried using the filter function and the formula FILTER(B:G,B:B>0,E:E>eomonth(today(),-1)), but unfortunately that only gave me the values in column B greater than 0, it did not filter the months correctly, and i couldnt link to the filtered table on another spreadsheet, it was just giving me 0.

Is there a better formula that might be able to accomplish this? Thanks so much for any help.

Cheers,
Ernie

 

[Fluff]

How about

=FILTER(B:G,(B:B>0)*(E:E>EOMONTH(TODAY(),-1)))

 

[erniepoe]

Thank you Fluff, that worked great!

 

[Fluff]

You're welcome & thanks for the feedback.