Dueling Excel – “Total by Week & Month”: Podcast #1692




About this tutorial:

Video duration: 9:22
Today we present a practical, personal, non-business use for Microsoft Excel: Personal Fitness Performance and Progress. Sent in by a YouTube viewer, Mike “ExcelisFun” Girvin and Bill “MrExcel” Jelen look at keeping track of ‘Pullups’ in a Spreadsheet and then getting the weekly and Monthly totals. Follow along with Mike and Bill, in Episode #1692, to see different methods for arriving at the anticipated results.

Dueling Excel Podcast #120…This episode is the video podcast companion to the book, “Slaying Excel Dragons: A Beginners Guide to Conquering Excel’s Frustrations and Making…

Post Author: OfficeTutes.com

Apple lover, ICT and LEAN consultant, MS Office lecturer My other website with video tutorials - Tutorials, guides and news for iPhones and iPads

5 thoughts on “Dueling Excel – “Total by Week & Month”: Podcast #1692

    Mudit Jain

    (January 10, 2019 - 12:01 am)

    =SUMIFS($E$2:$E$550,$A$2:$A$550,">="&F2,$A$2:$A$550,"<"&F3) I am applying same formula but the output (total sum week wise) also includes the F3 cell date entry. What should i do to rectify it

    Ernest Millinga

    (January 10, 2019 - 12:01 am)

    what when the criteria range are in the rows series and criteria are in column wise and you want to sumifs by weekly and monthly to date,while other factor like date criteria range are in columns and criteria are in rows series,
    Thank you and please assist,

    Cael Kai

    (January 10, 2019 - 12:01 am)

    Base on my sheet the M7 cell which the joined date have got a formula like this =VLOOKUP($C$3,VALIDATION!$A$2:$M$500,9,FALSE), so when I choose in C3 (drop-down list, different employee number will show) & the joined date in cell M7 will change, so from there the number of months in J11 will change according to the joined date. IF M7 GOT 1/3/2011 joined date (IT NEED TO BE CHANGE AS 1/3/2013 [2013 'coz preivous year of this year) SUBTRACT TO TODAY DATE 25/10/2014 SO I NEED THE ANSWER OF 19MONTHS (because 1/3/2013 to 1/3/2014 = 12 months or 1 year then + from 1/3/2014 to today date 26/10/2014 = 7 months so MUST BE TOTAL OF 12+7 = 19MONTHS… then only I can count how many entitled leave they can have to date. Somebody give me the formula it work only if the joined date is the same as this year 2014. but if need to count also from 2013 to 2014 (if employee is an old worker) then it has an error and it shows everytime is 15. I really need this badly. thank you.. Here's the formula..

    =IF(YEAR(TODAY())>YEAR(M7),((YEAR(TODAY())-YEAR(DATE(YEAR(TODAY())-1,MONTH(M7),1)))*12)+(MONTH(TODAY())-MONTH(YEAR(DATE(YEAR(TODAY())-1,MONTH(M7),1)))),MONTH(TODAY())-MONTH(M7))

    tinlunchboxes

    (January 10, 2019 - 12:01 am)

    Awesome – thanks very much for this. SUMIFS rock!

    Mike Dolan Fliss

    (January 10, 2019 - 12:01 am)

    SUMIFS, where have you been all my life. Good grief, the work-arounds I've used…

Leave a Reply

Your email address will not be published. Required fields are marked *