Hey everyone- here's what I'm looking to do:
I have a list of customers. I'm currently tracking how many jobs we do for each customer by day and my formula adds the total jobs for each customer by month. That part is fine.
What I'd like to do is add how much $ we charged for each of those jobs and total it for each customer per month the same way I'm totaling the number of jobs for each customer.
So cells in my calendar table will look something like this: ALLD - $500.50
I want to count "ALLD" as 1 job for ALLD (in one cell) and I want to count "$500.50" for 1 ALLD job (in another cell).
Is this possible? Please help. Thanks!
Bookmarks