Hi all,
i have one short question.
How can i use function COUNT in SUMPRODUCT function?
is it possible?
i tried something like this:
but it doesnt works=SUMPRODUCT(--(Prer!$D$4:$D$2000=Prer!$D$3);--(Prer!$M$4:$M$2000<>"C");--(Prer!$R$4:$R$2000="R");COUNTA(Prer!$C$4:$C$1500))
Till now i use counting in sumproduct with column, where was only number 1 and it counted basics this column.
It seems like this:
where column Z was only for help with number 1.=SUMPRODUCT(--(Prer!$D$4:$D$2000=Prer!$D$3);--(Prer!$M$4:$M$2000<>"C");--(Prer!$R$4:$R$2000="R");Prer!$Z$4:$Z$1500)
But this is not the right way in each case.
how can i fix it?
thx a lot