In the attached book, on the left, displays the total for each year. Cell A4 (and subsequently the years below) are automatically update as the years pass. May I receive some assistance developing a formula that will look within each year to update the total amounts for that year. Thanks
Use
=SUMPRODUCT(--(YEAR($D$2:$EI$2)=$A4),$D$3:$EI$3)
Last edited by Bob Phillips; 01-04-2015 at 02:45 AM.
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber
Hi XLD...the sum is display 0. Any ideas? I thought maybe I need to enter the formula using Shift-Enter, but that didn't work.
No it doesn't need Ctrl-Shift-Enter, it is not an array formula. I tested it on your worksheet and it worked here, as shown below.
04-01-2015 09-42-38.jpg
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber
My bad!!! I'm not sure what happened, but I'm pretty sure I goofed it up somehow. Thank you. It works. :-)
Posting Permissions
Reply With Quote
