Hello,
I have a problem that has been preplexing me. Have a file (see attached) that I need to sum specific rows of data from two worksheets into a consolidated worksheet. The specific problem I have yet to overcome is that there are specific rows of data that are not always consistent between the two worksheets and I want to use a formula that searchs for the category (name) in one column and searches to the specific month on each worksheets and sum the two amounts together for each one if finds. I hope this makes sense. I know there is a way to do this, but I can not get anything to work. Help please.
Bookmarks