Hi Everyone.
I have tried a few different formulas for what I thought was right however when they total up it doesnt match.
I need to know if sheet 'Shutters' colum 'G' shows "PLANTATION" and sheet 'Shutters' colum 'J' shows "CHATSWOOD" then the data is counted. if not then 0 is input
thanks
Bookmarks