Hi everyone!
Iโm trying to add an amount based on if the value is from this year.
I tried:
=SUMIF(inputs!B:B, โYEAR(B:B) = YEAR(TODAY)โ, inputs!F:F)
Where B column has the dates and F the amounts to Add. I canโt seem to make it work. Any tips/help?
Thanks!!
@David_Villafane Would it be better to use an app formula instead of sheet formula for this purpose?
User | Count |
---|---|
42 | |
34 | |
27 | |
23 | |
16 |