Thread
:
Need totals of values that fall within a given year
View Single Post
#
9
Ola
Posts: n/a
Sorry,
Try this:
AB1:
=SUM(IF(ISNUMBER($V$5:$V$2050+$Z$5:$Z$2050);($V$5: $V$2050)*(YEAR($Z$5:$Z$2050)=AA1);0)
Ola
Reply With Quote