Dear all,

Need your kind help here..

Summary!C71 is 1-jan-08

Summary!D71 is 1-feb-08

I am trying to sum up all the value that lies in S5:S1000 for all "PIP" in row B with all the dates that is between 1-jan08 and 1-feb-08.

The problem seems to lie in the bold red portion.

Once I remove the red portion, it work.

But I need to remove that to get the correct result

=SUMPRODUCT((B5:B1000="PIP")*(

Need your kind help here..

Summary!C71 is 1-jan-08

Summary!D71 is 1-feb-08

I am trying to sum up all the value that lies in S5:S1000 for all "PIP" in row B with all the dates that is between 1-jan08 and 1-feb-08.

The problem seems to lie in the bold red portion.

Once I remove the red portion, it work.

But I need to remove that to get the correct result

=SUMPRODUCT((B5:B1000="PIP")*(

**AND(I5:I1000>=Summary!C71,I5:I1000<summary!d71><summary!d71></summary!d71></summary!d71><summary!d71></summary!d71>**))*(S5:S1000))
Last edited: