Hello, i got this tiny problem with simplish(?) formula
a1 = date
b1 = number
c1 = number
d1 = date
e1 = number
f1 = number
etc..
sum of year 2013
sum of year 2014
if a1 year = 2014 take number only b1(ignore c1) and add it to sum of year 2014
This is what i got now on my hidden calculate row. Problem is that it also pops the c1 value on this row too
=IF(YEAR(A1=2014);B1;0)
Bookmarks