Excel Forum



Excel Magic Trick 679: Adding Yearly Totals From Monthly Data - Date Formatting Trouble (2 Examples)


See 2 examples of how to summarize yearly totals from monthly totals when there Year Criteria is entered as a serial date. See the SUMPRODUCT and SUMIFS functions. Learn about criteria and how to enter it into the SUMIFS functions. Use the ampersand to join comparative operators to value in cells to create criteria.

Download file: http://flightline.highline.edu/mgirvin/ExcelIsFun.htm





Got a Question? Ask it Here in the Forum.