I have multiple worksheets detailing projects from 2002, 2003 and 2004. Some
projects have multiple entries for each year. I need a way to create a
summary for each project on how many $ were added each year. Is there some
way for a function to pull multiple entries for each project and subtract
from the subsequent year to show how many $ were added each year? Also, each
worksheet has the project numbers in different order and adds new ones every
year. I need a function that can identify and sum all the rows with the same
project number as well as subtract from the next year. I know this is
confusing. I'd appreciate any help someone has to offer.