I have searched the forum and tried several of the answers but don't seem to get this to work without making the workbook size enormous.
Current formula works perfectly...except now I have multiples now in the range set as "TYPE" which I now need to sum.
The ranges are in a different sheet.
Have tried a sumif with all the different types but this over 7000 cells makes the workbook very cumbersome in size.
Any help is much appreciated.