Microsoft Office Forums

Go Back   Microsoft Office Forums > >
Reload this Page How do I formulate a daily average when i have multiple numbers per day?
Register FAQ

Reply
 
Thread Tools Display Modes
  #1  
Old 05-03-2018, 06:18 PM
tshep152 tshep152 is offline How do I formulate a daily average when i have multiple numbers per day? Windows 10 How do I formulate a daily average when i have multiple numbers per day? Office 2016
Novice
How do I formulate a daily average when i have multiple numbers per day? 		 
Join Date: May 2018
Posts: 1
tshep152 is on a distinguished road
Default How do I formulate a daily average when i have multiple numbers per day?

I'm creating a spreadsheet to see where I am with my work each month. I am a vendor for car dealerships and input each invoice into the spreadsheet. for example; column a is the date, column b is my invoice number, and column c is the price. on any given day I may have anywhere from 2-20 invoices. how do I put the daily average into a cell?
Reply With Quote
  #2  
Old 05-03-2018, 10:18 PM
ArviLaanemets ArviLaanemets is offline How do I formulate a daily average when i have multiple numbers per day? Windows 8 How do I formulate a daily average when i have multiple numbers per day? Office 2016
Expert
  
Join Date: May 2017
Posts: 873
ArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud of
Default
Code:
=sumifs(...)/countifs(...)
Reply With Quote
  #3  
Old 05-05-2018, 02:15 AM
p45cal's Avatar
p45cal p45cal is offline How do I formulate a daily average when i have multiple numbers per day? Windows 10 How do I formulate a daily average when i have multiple numbers per day? Office 2010 32bit
Expert
  
Join Date: Apr 2014
Posts: 871
p45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond repute
Default
It seems you're putting your data in a form perfect for pivot tables; give us an example spreadsheet to demonstrate possible solutions.
Reply With Quote
Reply

Tags
average, date, price

« Previous Thread | Next Thread »


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I formulate a daily average when i have multiple numbers per day? how do you formulate the date by pay period ending? crussell Excel 8 02-23-2016 07:38 AM
Help on the formulate hours meninio Excel 2 02-11-2011 04:56 AM
How do I formulate a daily average when i have multiple numbers per day? help with formulate refers to values meninio Excel 11 01-26-2011 10:00 AM
How do I formulate a daily average when i have multiple numbers per day? Formulate month in Excel 2010 meninio Excel 4 01-25-2011 12:13 PM
How do I formulate a daily average when i have multiple numbers per day? template for multiple adressees sent daily ? NORABUTCH Outlook 4 11-11-2010 10:36 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:57 AM.

Contact Us - Privacy Statement - Top

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