ADD SOME FORMULAS TO AN EXCEL SPREADSHEET

Status: Closed
Prize: £15
Entries Received: 16
Winner: KyrillosRizkalla

Winner

Contest Brief

Hi there. I'm looking for someone to add some formulas to a spreadsheet I use. There are 3 tabs on the attached spreadsheet. This is an invoice tracker breaking down, profit, product category etc. And I want the spreadsheet to calculate automatically the amount of orders, values, GP (gross profit) and lead source.

January 2023 tab shows an example of how this is used used month by month

Master tab is the black tab that is copied when a new month is started.

Master 2 tab is a duplicate of the Master tab and but I have inserted notes in red capitals explaining what I require.

I'm looking to make a quick decision on this one. Message with any questions.