Currently I am using this formula to group and sum rows in a spreadsheet by month using the month number: =SUMIF($V$2:$V$992,"5",$D$2:$D$992) with the "5" being May.
I would like to add to this formula something that tells it if the month is "1" then JAN, if "2" then "FEB," etc.
Bookmarks