
Completed
Posted
Paid on delivery
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.
Project ID: 40794806
51 proposals
Remote project
Active 6 days ago
Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs

I can upgrade your existing Excel workbook into an automated reporting tool that calculates daily, weekly, and monthly totals instantly as new records are added. I will use dynamic Excel Tables, SUMIFS, structured references, and PivotTables wherever appropriate to ensure accuracy and easy maintenance without unnecessary VBA. The workbook will include automatic daily running totals, clearly organized weekly and monthly summaries, and formulas that automatically accommodate new rows. I will also provide a short explanation identifying the key formulas and locations so you can maintain or modify the workbook independently. I have uploaded samples of similar Excel automation and dashboard projects completed by me earlier in my profile. With 10+ years of experience, I am a Chartered Accountant (ICAI) and CPA, with strong expertise in Excel automation, financial reporting, and data analysis. Payment & delivery assurance: ✅ No upfront payment ✅ Release payment after completion or milestone ✅ Regular update related to project ✅ Timely delivery ✅ 100% commitment to project completion I am confident I can deliver a reliable, user-friendly workbook that eliminates manual calculations. Looking forward to working with you!
₹1,000 INR in 1 day
3.7
3.7
51 freelancers are bidding on average ₹998 INR for this job

Hello, I can set up your existing workbook so daily entries are automatically included in daily, weekly, and monthly totals, without requiring any manual calculations. I would first check the current worksheet structure and date format, then use Excel Tables with structured references and SUMIFS formulas to ensure new rows are included automatically. I would keep the summaries clearly organized, either directly in the worksheet or on a separate summary tab, depending on what fits your layout best. I can also make the formulas easy to maintain and adjust later, without introducing VBA unless there is a clear benefit. You will receive the revised workbook along with a short explanation of the key formulas and where to find them. I would like to check existing workbook in order to get better idea how to complete, could you share? Thanks, Ivan V.
₹1,057 INR in 1 day
7.2
7.2

Totals that silently stop at the last old row, and weeks that straddle two months, are where these sheets usually break. Both covered. Day 1: your file back with live day, week and month totals plus a few test rows so you can confirm new entries are picked up. Day 2: final workbook and a short note on where each formula lives and how to extend it. Plain formulas, no VBA. 1. Does your week start on Monday or Sunday? 2. One grand total per period, or a breakdown by column or category as well? Send the workbook (or a copy with dummy figures) and I can start right away.
₹780 INR in 2 days
6.5
6.5

Hi, I can create Excel formulas that can automatically calculate your input data. I have advanced knowledge of Excel functions, data analysis and had a lot of similar projects in the past. We can discuss more details regarding this project. Thank you
₹1,500 INR in 1 day
6.4
6.4

Hi, I can upgrade your existing Excel workbook to automatically calculate daily, weekly, and monthly totals as you add new records. I'll use Excel Tables, SUMIFS formulas, and structured references to ensure new rows are automatically included, along with a clearly organized summary sheet for easy tracking. I'll also test the formulas to ensure everything updates correctly and provide a short explanation of where the key formulas are located so you can easily maintain or modify them later. I have over 20 years of experience in Excel and data processing, including formulas, PivotTables, and spreadsheet automation.
₹1,050 INR in 3 days
5.2
5.2

Your sheet already holds the daily entries, so the real fix is a structured table feeding live summaries, with no copying totals out by hand. I'd convert your data range into an Excel Table so every new row is picked up automatically, then use SUMIFS with structured references for the daily running total, plus a Summary tab that rolls daily figures into weekly (by ISO week) and monthly totals. No VBA, so nothing breaks when you tweak it later. Before sending it back, I'd test the formulas against sample rows and check that the totals match a manual sum. You'd get the revised workbook and a short note listing where each key formula lives and which range to change. See my portfolio in my profile and client reviews for similar Excel automation work. Are your dates in a single column, and does the week start on Monday or Sunday?
₹1,250 INR in 1 day
3.5
3.5

I can build the totals into your workbook so each new row you add updates the day, week and month figures on its own, and the daily running total will be on the sheet within a few hours of the award. The revised file and a short note on where the formulas live will be with you in two days. The part that usually breaks these is the date column. If some dates are typed as text, or a row has no date, the totals quietly skip it. I'll check every date before building on top of it, and the summary will show how many rows did not make it into a total. My profile has a project called Card statement CSV to accounting, where the totals had to reconcile to the cent, so this kind of check is familiar. The price is 1,000 INR total. I'll set weeks to run Monday to Sunday unless you tell me otherwise. I'm available now, and the first thing I'd build is the daily total, since everything else sits on top of it.
₹1,000 INR in 2 days
3.4
3.4

Hello, We will turn your daily log into a self updating workbook. The tricky part is making totals catch every new row without you extending ranges, so we will first convert the data range into an Excel Table so formulas grow automatically with each entry. Helper columns will derive the date, week number and month from each row. A daily running total will sit beside the entries using SUMIFS on structured references, so the figure for today updates the moment you type a line. A separate Summary tab will list daily, weekly and monthly totals with clear labels, built with SUMIFS over dynamic date lists so nothing needs manual refreshing. We will avoid VBA and use a PivotTable only if your layout makes it cleaner. You will receive the revised workbook plus a short note naming each key formula cell and how to adjust its range later. Which Excel version do you use? Should weeks start on Monday or Sunday? We suggest starting with the table conversion and daily totals on a copy of your file, then a 10-minute call on Freelancer to review our plan and proposed timeline so you can decide how to proceed. Can we arrange that call? Regards, Bits Collision
₹1,500 INR in 3 days
2.8
2.8

Hi, I have 4+ years of experience in Excel automation and advanced formulas. I can create a dynamic, error-free workbook that automatically calculates daily, weekly, and monthly totals without VBA. I'll deliver a clean, easy-to-maintain solution with a brief formula guide. Let's discuss your requirements!
₹1,000 INR in 1 day
2.5
2.5

Hi, I can update your existing workbook with formulas that automatically calculate daily, weekly, and monthly totals as you add new rows. I’ll use SUMIFS, Excel Tables, and a clearly organized summary sheet where appropriate, keeping everything easy to maintain without VBA. Please share your workbook so I can review its structure and implement the right solution.
₹601 INR in 1 day
1.6
1.6

Hi, I have strong experience in Excel automation, formulas, and dynamic reporting. I can upgrade your existing workbook so daily, weekly, and monthly totals update automatically whenever you add new records, without requiring manual calculations. I’ll use Excel Tables with structured references and SUMIFS formulas to ensure new rows are included automatically. I can also create a separate summary tab showing clearly labelled daily, weekly, and monthly totals, with formulas that remain easy to maintain and adjust. I’ll keep the solution formula-based without VBA unless there is a genuine advantage to using it. I’ll also test the workbook with additional sample entries to ensure the summaries update correctly and the calculations remain accurate. I have extensive experience building automated Excel trackers, financial reports, and dynamic dashboards. I can deliver the revised workbook along with a short explanation of where the key formulas are located and how to modify them. I’m ready to review your existing workbook and get started. Regards, Taha
₹1,050 INR in 7 days
2.6
2.6

Hi, I can transform your existing Excel worksheet into a fully automated reporting system that saves you hours of manual calculations and gives you accurate figures at a glance. I’ll build dynamic formulas using SUMIFS and structured tables so every new entry is automatically captured, with daily totals updating instantly and weekly and monthly summaries calculating without any extra effort. I’ll make sure the workbook is organised, reliable, easy to navigate and simple to maintain, without unnecessary VBA. I understand that accuracy is critical when working with figures, so I’ll thoroughly test the formulas before delivery. You won’t just get a spreadsheet that adds numbers; you’ll get a practical solution that makes tracking your data effortless. I’m ready to get started!
₹1,250 INR in 7 days
1.5
1.5

Hi, I will upgrade your Excel workbook to automatically calculate daily, weekly, and monthly totals as you add new rows, eliminating manual calculations. What you’ll get: * An Excel Table that expands automatically with new entries. * SUMIFS formulas for daily running totals and weekly/monthly summaries. * A clearly labeled summary sheet for quick reporting. * Structured references and clean formatting for easy maintenance. * A short guide showing where the key formulas are located and how to adjust them. I’ll keep the solution formula-driven, without VBA, and test it with additional sample rows to confirm the summaries update correctly. I can deliver the revised workbook within 1–2 days, depending on its structure. Please send me a message so we can get started immediately.
₹1,200 INR in 2 days
0.8
0.8

Excel reporting and data analysis are core strengths of mine, making me well suited to automate your daily, weekly, and monthly totals directly within the workbook. I can build reliable formulas using Excel functions such as SUMIFS and structured references so newly added rows are included automatically without requiring manual calculations. My experience with data processing, Excel reporting, and Visual Basic also allows me to keep the workbook practical and maintainable. I can organize the results into clearly labeled cells or a summary tab, with formulas positioned so ranges can be adjusted easily later. I will also provide the revised workbook along with a concise note identifying the key formulas and their locations. I’m ready to turn your current worksheet into a clear, self-updating reporting file and would be glad to deliver a clean solution tailored to your workflow.
₹1,050 INR in 7 days
0.6
0.6

Putting the data in an Excel Table is what lets new rows get picked up with no ranges to stretch. I'd add a week-start helper column so weekly totals don't split at year end, and check every total against a plain sum of the raw rows. The nearest thing I've built is a spreadsheet import step inside a Node pipeline that shipped nearly 300 iOS apps from data files. Price assumes one date column, up to three number columns and Monday-start weeks, otherwise I send a revised quote before I start; 14 days of fixes included. What columns does your sheet hold today?
₹700 INR in 2 days
0.0
0.0

I can add daily, weekly and monthly totals directly to your existing workbook using an Excel Table and SUMIFS formulas, so new rows are included automatically. For ₹1,500 fixed, my scope is one existing input worksheet with one date field and one numeric amount field, plus a clearly labelled summary area/tab and a short formula guide. No VBA or PivotTable is needed for that scope. I will confirm your Excel version and preferred week start, preserve the original data, and check totals against sample rows across day, week, month and year boundaries. I will also test that appending a row changes the appropriate totals. Estimated effort is about 1–2 hours; delivery within two days after receiving the workbook and confirming those fields. One focused revision to the agreed summaries is included. If your workbook has multiple unrelated amount fields or needs source-data repair, I will flag that before work rather than expand this price silently. Please fund the ₹1,500 milestone before work begins.
₹1,500 INR in 2 days
0.0
0.0

Hi dear client, i've read your project description and i'm really interested about it. Just leave a message !!!
₹600 INR in 1 day
0.0
0.0

Hi. I'm a specialist in Excel (VBA included despite we won't use it) and I can help you with this task. I communicate on chat and get paid only through Freelancer. Hope to hear from you. Have a nice day.
₹600 INR in 7 days
0.0
0.0

You get a workbook that instantly totals new daily data rows and rolls those into weekly and monthly summaries in clear summary cells or tabs. I build Python data automations for small teams. I'll add SUMIFS formulas keyed to your date column for daily totals, then use structured references to aggregate these into weekly and monthly summaries on a separate sheet, keeping everything formula-based and easy to adjust. First delivery within 24 hours, then on your schedule. Which date format do you use in your worksheet to identify each data row's day? Gilbert Losert
₹600 INR in 1 day
0.0
0.0

I'll set up your workbook so daily, weekly and monthly totals update by themselves as you add rows, with no VBA. Plan: - Convert the data to an Excel Table so new rows are picked up automatically - Add a running daily total with SUMIFS - Build a labelled Summary tab with weekly and monthly totals - Write a short note on where each key formula lives It'll be done within a day of getting the file, and you can check it before paying through a milestone. I'm new on Freelancer and looking for my first review. I study Economics at Warwick (First in first year, Statistical Techniques 83%) and work in Excel, Python and SQL. Which Excel version do you use (365 or older)?
₹600 INR in 1 day
0.0
0.0

I will return the revised workbook the same day you send a sample of the sheet, or just the column names and one example row. Every new row will add into that day's running total on the sheet, and those days will roll into weekly and monthly totals on a labeled summary tab, with SUMIFS so you can change the ranges later. No VBA. A short note will say where each formula lives. I built the finance view in DMCommerce, the store platform I run, where each sale lands in the day and the period the owner actually checks. 1500 INR for this scope, entry price while I collect reviews here.
₹1,500 INR in 1 day
0.0
0.0

Darbhanga, India
Payment method verified
Member since Dec 1, 2021
₹600-1500 INR
$30-250 USD
₹750-1250 INR / hour
₹12500-37500 INR
$250-750 USD
₹100-400 INR / hour
$250-750 USD
$30-250 USD
₹12500-37500 INR
$30-250 USD
$30-250 USD
$250-750 USD
$250-750 USD
₹1500-12500 INR
₹750-1250 INR / hour
₹12500-37500 INR
$4-50 USD / hour
£20-250 GBP
₹1250-2500 INR / hour
₹600-1500 INR
₹750-1250 INR / hour