Formula? Taking totals from lists

[Gingertiger77]

I have a current list of x30 Clients that have been numbered 1 to 30.
Each day of a month is allocated one of the client reference number and a total spend value.
Each month will only have a maximum of 6 different clients listed in any one month. I want to see the monthly total spend of up to 6 clients.
What formula would be the best to use? - See attachment example.

[6StringJazzer]

Your post does not comply with Rule 1 of our Forum Rules. Please update your title to tell us something about your specific question. Describe your problem, not your anticipated solution. We ask this for two reasons:

1. Members scan the list of threads to decide where they can help. The title helps us decide which questions we have the knowledge to solve.
2. After a question is answered, the title helps people with similar questions find it in a search.

Use terms appropriate to a Google search. Examples of poor thread titles are Please Help, Urgent, Need Help, Formula Problem, Excel Question, Code Problem, and Need Advice.

To change a Title go to your first post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7.

[shivya]

How can anyone suggest you "which formula is required" without any data?
Attach a sample sheet, this task needs the combination of formulas instead, any single formula.

[6StringJazzer]

This is a job for a pivot table. I have created one for you, see attached. Note that all of the "Type" values in your table must be the same; you have "Ongoing " with a space which is different than "Ongoing", so I removed the extra space.

[Gingertiger77]

Thanks! :-)