well it seemed a simple task

[bigtounge1]

well i hought this would be simple but nothing I've tried works. Here's what i have:

lets call cell A2 the info block
lets call B1 a refrence cell
and B2 is where i need the work done

Cell A2 is a dialog type cell. serveral names and dates and info are in the cell
Cell B1 is a name pulled from another worksheet.
in cell B2 I need a formula that will count the number of times name A (B1) show up in cell A2(paragraph).

Another aspect of the worksheet that i could probably get after i fix this probleem is :

Cell B3 is a month i need to pull B2 if B3 = referenced month on a table.

Anyone ... I hate my boss lol