View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
ingalla
 
Posts: n/a
Default formula question

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