Mar 10, 2022
Filter data for current year only
I would like that the filter applies to the current year instead to the given range, maybe using C3.
Details
Informational notification.
This question is locked and replying has been disabled.
Community content may not be verified or up-to-date. Learn more.
Last edited Mar 10, 2022
Hi, Juergen Kimmel,
Try the following and see if it gives the expected result.
This is based on the year that is entered into cell C3
=counta( filter( $D4:4 ; year( D$2:$2 )= $C$3 ) )
I hope this helps,
Ben Liebrand
Original Poster Juergen Kimmel marked this as an answer
All Replies (2)
Hi, Juergen Kimmel,
Try the following and see if it gives the expected result.
This is based on the year that is entered into cell C3
=counta( filter( $D4:4 ; year( D$2:$2 )= $C$3 ) )
I hope this helps,
Ben Liebrand
Original Poster Juergen Kimmel marked this as an answer
Hi, Juergen Kimmel,
I am glad to see the formula worked for you.
Ben Liebrand