![]() |
#1
|
|||
|
|||
![]()
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?
|
#2
|
|||
|
|||
![]() Code:
=sumifs(...)/countifs(...) |
#3
|
||||
|
||||
![]()
It seems you're putting your data in a form perfect for pivot tables; give us an example spreadsheet to demonstrate possible solutions.
|
![]() |
Tags |
average, date, price |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
crussell | Excel | 8 | 02-23-2016 07:38 AM |
Help on the formulate hours | meninio | Excel | 2 | 02-11-2011 04:56 AM |
![]() |
meninio | Excel | 11 | 01-26-2011 10:00 AM |
![]() |
meninio | Excel | 4 | 01-25-2011 12:13 PM |
![]() |
NORABUTCH | Outlook | 4 | 11-11-2010 10:36 AM |