Automate Excel Totals & Results
Budget / Salary₹600–1,500
TypeFreelance project
LocationRemote
Posted1 hour ago
I record several lines of data every day in a single worksheet and would like that same file to show me daily, weekly, and monthly totals without any manual effort. Right now the figures have to be added up outside the sheet, so I want formulas (e.g., SUMIFS, structured references, maybe a PivotTable if it helps) built straight into the workbook.
The upgraded file should:
• Pick up every new row I add and instantly show the running total for the day on the sheet.
• Roll those daily numbers into weekly and monthly summaries in clearly labeled cells or a summary tab.
• Stay easy to maintain—no VBA is required unless it truly simplifies the job.
Once finished I only need the revised workbook and a short note explaining where the key formulas live so I can tweak ranges later if needed.
The upgraded file should:
• Pick up every new row I add and instantly show the running total for the day on the sheet.
• Roll those daily numbers into weekly and monthly summaries in clearly labeled cells or a summary tab.
• Stay easy to maintain—no VBA is required unless it truly simplifies the job.
Once finished I only need the revised workbook and a short note explaining where the key formulas live so I can tweak ranges later if needed.
Apply on Freelancer →
Project sourced from Freelancer.com. Applications happen directly on the original platform — we never collect your data.