david gabra
Member
Hi
I have
=IF(L3=$T$21,$T$20,COUNTIF(Testing_Main!$K$10:$K$147,L3))
I need to add another AND ---- so that it should only add a number in the cell if this is also a number the M column of the row that is beng checked.
If there M cell is blank in the row, then it shoud return an empty result - the cell to should be blank
is that clear?
thanks
I have
=IF(L3=$T$21,$T$20,COUNTIF(Testing_Main!$K$10:$K$147,L3))
I need to add another AND ---- so that it should only add a number in the cell if this is also a number the M column of the row that is beng checked.
If there M cell is blank in the row, then it shoud return an empty result - the cell to should be blank
is that clear?
thanks