Ok so I have two unhidden tabs on the attached spreadsheet.....
Hopefully the results I want to see are quite self-explanatory. I want the formula in the second tab, to look at the cost information in the first tab and show me cost total for anything coded to "OR" and "GBNHA271693".
I've used this formula, for this kind of task before but it's not playing ball today. Anybody any ideas?
Bookmarks