G'day John

With regards to your comment responding to Roger

By the way, I didn't think it was possible to include text values in a
SUMPRODUCT formula. The cell name is text. So is the status code "Assembly".
That's why I was originally looking for a MATCH INDEX formula. I hope I'm
wrong here as I would prefer a SUMPRODUCT formula.

I use a a 4 Criteria SUMPRODUCT:

=SUMPRODUCT(--('2008'!$B$5:$B$2004="SYD"),--('2008'!$D$5:$D$2004="ADE"),--('2008'!$E$5:$E$2004="01.JAN"),--('2008'!$N$5:$N$2004="Accident"))

Works fine for what I use it for.

HTH
Mark.