countif
hello,
i am trying to write following formula, but.............
sheet 1 Sheet 2
A_col B_col A_col B_col C_col
japan 10 japan 10 formula would be here
(C1)
korea 40 london 35
japan 10 tokyo 22
=countif('sheet 1'!a1:a20='sheet2'!=a1)*('sheet 1'!b1:b20='sheet 2'!b1))
but this formula doesn't work, acctully i want count like Japan = 10 from
sheet-1 into sheet-2.
Thanks in advance.
|