sumproduct + index

[bluepenink]

hello

having some trouble with this formula...not sure why the error is appearing.

$ of all invoices:

=SUMPRODUCT(--(INDEX(_Data,0,10)>=$D$10),--(INDEX(_Data,0,10)<=$D$10+6),--(INDEX(_Data,0,12)))

 

[Aladin Akyurek]

hello aladin

im not quite, sure D10+0 gives me the same answers as the value in D10, which is 6-june-2011 or whatever the selected date is....am i missing something, sorry?

I asked whether you have formula in the area covered by _Data.

You said: "yes there are formulas in some ranges"

I asked you to post some of those formulas and still asking to do so. The reason: They might be causing the trouble.