I would like to add the data highlighted in Col A, which I have named "other_Income". The values applicable to these items are in Columns F, I & J
I have used the sum function to show you what the answer should be. Could one use a range name and then an offset function to add the values based on the criteria or use sumifs?
It would be appreciated if you could assist me with a formula to add a series of data based on crieria such as this.
Bookmarks