Excel Forum



Excel Magic Trick 749: Add Yearly Totals From Daily Date Data without SUMIF Function


Download file: http://people.highline.edu/mgirvin/
See how to Add Yearly Totals From Daily Date Data Formula Method using SUMPRODUCT and YEAR functions. See how SUMIF can't handle arrays.





Got a Question? Ask it Here in the Forum.