This is probably a very simple formula required but I am struggling with it. Can somebody please assist?
We have a number of clients on one sheet where we track different trades budget vs. actual for each client. e.g. Plumbing, Electrical, Carpentry etc.
- We want to count up all the budgets for the Plumbing for all clients
- We want to count up all the actuals for the Plumbiing for all clients
- .....and the same for all the other trades
Attached is a snippet of the current layout. Each client is formatted the same; one under the other.
Lastly I want to display all these metrics on a dashboard :)
Thank you in advance.