View Full Version : [SOLVED:] horizantal total
av8tordude
01-04-2015, 12:18 AM
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
Bob Phillips
01-04-2015, 02:01 AM
Use
=SUMPRODUCT(--(YEAR($D$2:$EI$2)=$A4),$D$3:$EI$3)
av8tordude
01-04-2015, 02:20 AM
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.
Bob Phillips
01-04-2015, 02:43 AM
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.
12678
av8tordude
01-04-2015, 02:46 AM
My bad!!! I'm not sure what happened, but I'm pretty sure I goofed it up somehow. Thank you. It works. :-)
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.