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