count if function

[khalil]

hello All, please help in this one

for example;
A1 Chair
A2 Chair
A3 Chair
A4 Chair
A5 Table
A6 Chair
A7 Chair
A8 Chair

what i want is to count how many chairs before the column interrupted with table, after table i want to count the chairs after table,

i want the number to be in one cell

i.e before the word table the cell counts 4 chairs, then after table the cell counts 3 chairs,


thanks in advance

 

[khalil]

thanks man, it works, i appreciate your help,
if you dont mind can you help me in the one below,

p1=a1 if a1=h1 and k1 is blank, and if k1 is not blank then p1 =k1




thanks again