Hello,
I have this file that I have acquired from a previous co-worker. I wanted to manipulate the formula. But i hope the understand what the formula is.
=SUMIF('MISC.'!$L:$L,"="&($A6&TEXT(C$4,"mmm-yy"))
I would like to change the mmm-yy to just Year.
Thank you .
Bookmarks