You may simply need to put the -- in front of each array and separate the
arrays by commas rather than multiplication signs:
=SUMPRODUCT(--('Supplies DO - STPs'!A4:A7'Supplies Weekly'!A3),--('Supplies
DO - STPs'!A4:A7<'Supplies Weekly'!A3+6),--('Supplies DO -
STPs'!C4:C7=Data!F5))


"ingalla" wrote:

Can anyone tell me what is wrong with the following formula..

=SUMPRODUCT(('Supplies DO - STPs'!A4:A7'Supplies Weekly'!A3)*('Supplies DO
- STPs'!A4:A7<'Supplies Weekly'!A3+6)*('Supplies DO - STPs'!C4:C7=Data!F5))

Here is the data it should be looking at.

date entry type
06/06/2006 DO Book
12/06/2006 DO Book
13/06/2006 DO Book
11/06/2006 DO Book


Thanks andy