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")*(AND(I5:I1000>=Summary!C71,I5:I1000<summary!d71><summary!d71></summary!d71></summary!d71><summary!d71></summary!d71>))*(S5:S1000))
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: