In my google sheet, I have trade entries with dates. I am trying to prepare sheet which can provide the number of trades in each months depends upon the year selected. I am trying use filter function to filter the year first, and then month and then trade count. But current function always giving zero result. Is this approach correct ?
which we will check for consistency with Year
& Month
& "Trade"
data, but only instead of one month you can substitute all 12 months using the formula SEQUENCE(1,12,1,1,1)