formula question

I

ingalla

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
 
B

bpeltzer

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))
 
F

Franz Verga

Nel post *ingalla* ha scritto:
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
Click to expand...

Hi Andy,

What is the result you have and what is the wanted result?

The formula seems to work for me...

Maybe you can specify what are the ranges in tour formula...


--
Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy
 
B

Bob Phillips

If you are not getting proper results, the most likely problem is that the
dates are text fields, not date. Check that.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 
Top