Hey, the problem is that i want to use sumproduct based on 2 ranges to search from third range, the problem is that in the third range are codes which include text strings : TT9298473 so in the 1-st range are car registration numbers and in the second range are dates, if they match the formula should output the corresponding code from 3-rd range
Is there a way that sumproduct accepts text strings ???
My current formula looks like this :
=SUMPRODUCT(--(Kütusetabel!$C$3:$C$200=$A$1);--(Kütusetabel!$D$3:$D$200=$A4);(Kütusetabel!$K$3:$K$200))
Would someone PLEASE post a solution I really need the solution
Is there a way that sumproduct accepts text strings ???
My current formula looks like this :
=SUMPRODUCT(--(Kütusetabel!$C$3:$C$200=$A$1);--(Kütusetabel!$D$3:$D$200=$A4);(Kütusetabel!$K$3:$K$200))
Would someone PLEASE post a solution I really need the solution