I can't quite get this formula to work. I need several. My employees's pay
are based on the number of transactions closed by that employee in a calendar
month. We pay bi-weekly. Funding checks for February transactions were still
coming in last week (middle of March). I've more or less got it broker down
into doable parts. I am open to suggesstions on any part, but here's what I
specifically need: Accounting will enter check information into a "Master"
worksheet which will have a running total going back 4 to 6 months or so.
Accounting will enter the checks daily as they come in the mail. We pay
biweekly on Thursdays, checks must be in house by the Friday before to be
paid the following week. I've already created a timestamp that rounds up the
the next pay date taking into account the next deadline. I need one formula
that counts the number of transactions per employee per month for the first
pay date of the month, second, paydate of the month...(as more transactions
close, their commision split increases retroactively to the first transaction
of that month). Also need one that will sum the total profit on each of these
with the same conditions. Here's my example:
Column A = Employee name. Column B = Client name. Column C = Month
transaction took place. Column D = Next pay date (auto calculates already),
Column E = Profit for this Transaction (direct entry from check) Column F =
The number of transactions for this employees completed for the same month as
this check, to date as of the next pay date (Help here please), Column G =
The total profit for all of those checks that were counted in Column E.

Thanks,