Formula to calculate summary of expenses from expense columns by column day

[Joey81]

Hi All

Just wondering if anyone could help with this one.....I have a spreadsheet with weekly detailed expenses analyised by day and date under relevant expense column. I then need to summarise total costs on a separate spreadsheet, totalled by day under relevant expense column so I just end up with a spreadsheet totalling monday to sunday expenses.

Hope this makes sense?

Thanks for in advance for reading my post.

[Sindhus]

Hi, If you want to sum your data based on expense column, You can try sumif function.

[Pepe Le Mokko]

A Pivot Table is also a possibility