Home > Software design >  COUNTIF with Filter function in google sheet
COUNTIF with Filter function in google sheet

Time:11-07

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 ?

enter image description here

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)

enter image description here

  • Related