Calculating Total Spend For A Dashboard

[craigb1979]

Hi

I have a spreadsheet that used as a sales report with 12 worksheets one for each Month, and a dashboard worksheet.
On each monthly worksheet I have column B that contains the names of a companies that has purchased from me
Column C contains the value of the sale
Is there a formula that I can add to the dash board that will calculate how much each company has spent over the entire month ?
I hope that makes sense
Thank you as always
Craig

[TABLE="width: 500"]
<tbody>[TR]
[TD]Client[/TD]
[TD]Spend[/TD]
[/TR]
[TR]
[TD]ABC Holidays[/TD]
[TD]100[/TD]
[/TR]
[TR]
[TD]123 Travel[/TD]
[TD]200[/TD]
[/TR]
[TR]
[TD]Spain Tours[/TD]
[TD]400[/TD]
[/TR]
[TR]
[TD]ABC Holidays[/TD]
[TD]100[/TD]
[/TR]
[TR]
[TD]123 Travel[/TD]
[TD]150[/TD]
[/TR]
[TR]
[TD]ABC Holidays[/TD]
[TD]200[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[Fluff]

Have a look at sumif https://exceljet.net/excel-functions/excel-sumif-function