Summary Report Formula
What is the formula for this scenario:
I have laborers working at different job addresses, I want to calculate the total cost by Laborer Name and by each Job Address in a summary report. Below is the data.
The result I am looking for would look something like this in a summary report for my bookkeeper to easily write checks by job and address. I am required to write separate checks from different bank accounts on each job. No Co-Mingling.
Worker #1 123 Main St Total=$500
Worker #1 1st St Total=250
Worker #2 1st St Total= $400
Worker#3 123 Main St= $200
Is this possible?