Hello,
I am in need of 2 separate formulas. They can be added in columns J and K. I need one formula that can give me the employee count for each employer. And then I need another formula that can sum up the gross pay until it reaches $1,000 and return the date from column H. So for instance the employee count for John Doe is 1, and John Smith 2. And then the date for the gross pay for John Doe would be 1/27/2023, because that's the date where his gross pay hit $1,000. And for John Smith it would be 1/13/2023. I have attached a test spreadsheet. I haven't started any formulas for this. Thank you in advance for your help.
I am in need of 2 separate formulas. They can be added in columns J and K. I need one formula that can give me the employee count for each employer. And then I need another formula that can sum up the gross pay until it reaches $1,000 and return the date from column H. So for instance the employee count for John Doe is 1, and John Smith 2. And then the date for the gross pay for John Doe would be 1/27/2023, because that's the date where his gross pay hit $1,000. And for John Smith it would be 1/13/2023. I have attached a test spreadsheet. I haven't started any formulas for this. Thank you in advance for your help.