=IF formula help

[levanoj]

so hopefully this is a simple problem to solve.

I need a formula to be entered in Cell B2 of Sheet1 that says:

If the value in cell A2 of Sheet1 is equal to the value in cell A2 of Sheet2 then count the cells in column B of Sheet2 that are not empty.

 

[barry houdini]

Try this formulain sheet1 cell B2

=IF(A2=Sheet2!A2,COUNTA(Sheet2!B:B),"")