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!!
User | Count |
---|---|
38 | |
35 | |
27 | |
23 | |
18 |