Reply to thread

Message: [QUOTE="Forgone, post: 3868729"] I ended up doing the.... =TRUNC(SUM((ccb=$B7)*(ccd=$C7)*(cce=$D7)*('Workings'!AF$7:AF$345)) _ +SUM((ccb=$B7)*(ccd=$C7)*(cce=$D7)*('Workings'!AG$7:AG$345)),2) When I 2 columns I had to sum up and =TRUNC(SUM((ccb=$B7)*(ccd=$C7)*(cce=$D7)*('Workings'!AF$7:AF$345)) _ +SUM((ccb=$B7)*(ccd=$C7)*(cce=$D7)*('Workings'!AG$7:AG$345)) _ +SUM((ccb=$B7)*(ccd=$C7)*(cce=$D7)*('Workings'!AH$7:AH$345)),2) When I had 3 columns to sum up.... I just changed the column numbers and it worked fine. [/QUOTE]