Macropod et al,

I've incorporated the formulas into my actual spreadsheet, but for some darn reason the formulas will not work or recognise one particular row.

I'm afraid I can't really post the sheet (data protection issues) which I understand might make this totally useless.

The formula =DATEVALUE(COLUMN()-1&" "&MID(CELL("FILENAME",'July 2015'!$A$1),FIND("]",CELL("FILENAME",'July 2015'!$A$1))+1,LEN(CELL("FILENAME",'July 2015'!$A$1))-FIND("]",CELL("FILENAME",'July 2015'!$A$1)))) is correct in each cell it appears in

The row which will not work is Row 15 which has the following formula =SUMPRODUCT(('July 2015'!$I$2:$I$199=$A15)*('July 2015'!$H$2:$H$199=I$21),'July 2015'!$E$2:$E$199) and again everything appears to be correct and consistent with other rows.

The result should be returning a total for 'Tom', but refuses to do so, I've changed the name, inserted a new row etc, but to no avail.

Am I missing something totally obvious???

A very puzzled Ballst...