Hi,
You need to set up a table with the years say in column F, then use SUMIF
=SUMIF($A$2:$B$100,F2,$B$2:$B$100)
Hi,
You need to set up a table with the years say in column F, then use SUMIF
=SUMIF($A$2:$B$100,F2,$B$2:$B$100)
oldchippy
-------------
![]()
![]()
Blessed are those who can give without remembering and take without forgetting
If you are happy with the help you have received, please click the <--- STAR icon on the left - Thanks.
Click here >>> Top Excel links for beginners to Experts
Forum Rules >>>Please don't forget to read these
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks