similar text cells
Dear all,
i would like to request your help in this issue:
I have an excell sheet consiset of 4 column ( column A has text , column B has anumbers )
i need to do:
- for example i need to count similar text ( start )in ( A ) but only for value (1) from ( B) and put the total in D2
if B = 1
{
if A =" START "
{
D2 = NUMBER OF repeated cell by START in column A
}
}
how can i do that in sheet
Thanks in advance
Maher
Attachment | Size |
---|---|
Sample.xlsx | 8.79 KB |
=IF(B2=1,COUNTIF(A:A,A2),0)
=IF(B2=1,COUNTIF(A:A,A2),0)