craigb1979
New Member
- Joined
- May 5, 2014
- Messages
- 10
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
<tbody>
</tbody>
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
Client | Spend |
ABC Holidays | 100 |
123 Travel | 200 |
Spain Tours | 400 |
ABC Holidays | 100 |
123 Travel | 150 |
ABC Holidays | 200 |
<tbody>
</tbody>