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

AttachmentSize
Sample.xlsx8.79 KB
akmughal's picture

=IF(B2=1,COUNTIF(A:A,A2),0)

=IF(B2=1,COUNTIF(A:A,A2),0)