Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 12-09-2019, 05:27 PM
bugmeso bugmeso is offline Excel program, averages in line Windows 10 Excel program, averages in line Office 2010 64bit
Advanced Beginner
Excel program, averages in line
 
Join Date: Mar 2011
Location: W. PA
Posts: 31
bugmeso is on a distinguished road
Default Excel program, averages in line

For years I have kept track of the house utilities as in average OD temp for the month, total monies spent per month with totals at the at the end of an Excel line, total KW or CFM per month. I also keep track of the amount of the cost for KW per month. WHAT I WOULD LIKE TO KNOW: is there a formula for making an average per month at the end of the 12 month basis. And average each month as entered each month. Now that we moved into an all electric house. Thanks
Reply With Quote
  #2  
Old 12-09-2019, 07:12 PM
Logit Logit is offline Excel program, averages in line Windows 10 Excel program, averages in line Office 2007
Expert
 
Join Date: Jan 2017
Posts: 533
Logit is a jewel in the roughLogit is a jewel in the roughLogit is a jewel in the rough
Default

Add your 12 monthly averages for each category, then divide that by 12.
Reply With Quote
  #3  
Old 12-09-2019, 07:22 PM
bugmeso bugmeso is offline Excel program, averages in line Windows 10 Excel program, averages in line Office 2010 64bit
Advanced Beginner
Excel program, averages in line
 
Join Date: Mar 2011
Location: W. PA
Posts: 31
bugmeso is on a distinguished road
Default

LOL.....Not to be smart, that is the EXACT same thing my wife said
Reply With Quote
  #4  
Old 12-09-2019, 07:24 PM
Logit Logit is offline Excel program, averages in line Windows 10 Excel program, averages in line Office 2007
Expert
 
Join Date: Jan 2017
Posts: 533
Logit is a jewel in the roughLogit is a jewel in the roughLogit is a jewel in the rough
Default

.
Don't let her know .... you'll never live it down.
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2010 does not come to default program big issue everything i have checked. Farhan ud din Excel 3 10-06-2019 02:38 PM
Excel program, averages in line Calculations of dropdowns and formfield averages Joebawca Word 2 11-09-2017 02:10 PM
Formula that calculates cumulative averages lonniepoet Excel 2 02-04-2016 06:31 PM
Taking Averages with N/A's lynchbro Excel 5 01-07-2015 10:42 AM
Excel program, averages in line Program to read Email subject line word by word john23# Outlook 1 02-14-2014 10:21 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 09:06 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft