## Calculate weekly and monthly total in spreadsheet

Question!

How to calculate weekly sum (sum of last 7 rows printed in 7th row) based on daily values, same question for monthly (based on weekly or daily). I have tried some formulas but they all failed.

(first column is date column, not in image)

P.S. sorry for "too localized" and "not constructive" I just don't know how to ask this differently

For weekly column

``````=IF(IFERROR(WEEKNUM(A2)=WEEKNUM(A1), FALSE), "",SUM(B2:B8))
``````

for monthly column

``=IF(IFERROR(MONTH(A2)=MONTH(A1), FALSE), "",SUMIF(A2:A33, "``
``` By : Ross Larson ```
``` For the week column, you can add a formula like =IF(WEEKDAY(A8)=7,sum(B2:B8),"") (to put the sum of the week on Sundays. For the month column: =IF(MONTH(A2) By : assylias This video can help you solving your question :) By: admin ```
``` Related Questions how can you parse an excel (.xls) file stored in a varbinary in MS SQL 2005? xls to text converter Open an Excel 2003 spreadsheet with C#. Could not find installable ISAM. Exception Excel spreadsheet generation results in “different file format than extension error” when opening in excel 2007 (adsbygoogle = window.adsbygoogle || []).push({}); xls cascading lookup based on pivot table style datasource? How to remove xla from xls without renaming or deleting xla file? dsolefile - error handling when value does not exist (in excel) How to change pivot table data source in Excel? [closed] programatically add module to xls 2003 using vbscript “50289 Can't perform operation since the project is protected” but why? CSV to XLS linux script Protect excel file with java Character encoding issues when reading XLS files with PHP Read XLS file from VB6 Making new colors in JExcelApi JBOSS create PDF, XLS pyExcelerator has problems reading some files Exporting .xls to .csv issues What's XLSHTML? xhtml/rst to excel conversion ```
``` ```
``` About Us    Contact Us    Legal    feedback    Copyright © 2015 - All Rights Reserved - www.4answered.com ```