In the enclosed sample data. I need to calculate month-wise sum of quantity for each year in both ranges M4:X13, M17:X26. I have tried to calculate it thru SUMIFs but its not working. My existing SUMIF formula is mentioned in M4 and M17.
Kindly help.
Bookmarks