Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I get the average price per bid for an individual month?
I need a function that will return the average for the total bids in an
idividual month. |
#2
|
|||
|
|||
This really isn't a complete question, so I am assuming all the bids are on a single spreadsheet. If you have all your bid in a column, just go to the last empty cell of said column and enter this: =average(A2:A50) Is this what you are asking? PZan -- PokerZan ------------------------------------------------------------------------ PokerZan's Profile: http://www.excelforum.com/member.php...o&userid=23480 View this thread: http://www.excelforum.com/showthread...hreadid=391432 |
#3
|
|||
|
|||
What I have is a list of the jobs that we have bid for multiple months on a
single spreadsheet. Included in this imformation is a column with the date and a column with the price. What I would like to do is have a function that will return the average bid price for each month. I know how to count the number of bids for each month, but I don't know how to extract the prices out of the price column for the corresponding date. ex. sheet job bid date bid price 001 6/23/05 $5656 002 6/26/05 $7878 003 7/2/05 $4523 004 6/30/05 $6756 Question: how do I write a function that will look at the jobs in June and take the average of their bid prices, excluding the price of the job in July? "PokerZan" wrote: This really isn't a complete question, so I am assuming all the bids are on a single spreadsheet. If you have all your bid in a column, just go to the last empty cell of said column and enter this: =average(A2:A50) Is this what you are asking? PZan -- PokerZan ------------------------------------------------------------------------ PokerZan's Profile: http://www.excelforum.com/member.php...o&userid=23480 View this thread: http://www.excelforum.com/showthread...hreadid=391432 |
#4
|
|||
|
|||
One way
=SUMPRODUCT(--(MONTH($B$2:$B$1000)=6),$C$"2$C$1000) Change ranges to suit -- Regards Roger Govier "matt" wrote in message ... What I have is a list of the jobs that we have bid for multiple months on a single spreadsheet. Included in this imformation is a column with the date and a column with the price. What I would like to do is have a function that will return the average bid price for each month. I know how to count the number of bids for each month, but I don't know how to extract the prices out of the price column for the corresponding date. ex. sheet job bid date bid price 001 6/23/05 $5656 002 6/26/05 $7878 003 7/2/05 $4523 004 6/30/05 $6756 Question: how do I write a function that will look at the jobs in June and take the average of their bid prices, excluding the price of the job in July? "PokerZan" wrote: This really isn't a complete question, so I am assuming all the bids are on a single spreadsheet. If you have all your bid in a column, just go to the last empty cell of said column and enter this: =average(A2:A50) Is this what you are asking? PZan -- PokerZan ------------------------------------------------------------------------ PokerZan's Profile: http://www.excelforum.com/member.php...o&userid=23480 View this thread: http://www.excelforum.com/showthread...hreadid=391432 |
#5
|
|||
|
|||
Sorry, getting tired and clumsy fingers. That should read
=SUMPRODUCT(--(MONTH($B$2:$B$1000)=6),$C$2:$C$1000) Change ranges to suit -- Regards Roger Govier "Roger Govier" wrote in message ... One way =SUMPRODUCT(--(MONTH($B$2:$B$1000)=6),$C$"2$C$1000) Change ranges to suit -- Regards Roger Govier "matt" wrote in message ... What I have is a list of the jobs that we have bid for multiple months on a single spreadsheet. Included in this imformation is a column with the date and a column with the price. What I would like to do is have a function that will return the average bid price for each month. I know how to count the number of bids for each month, but I don't know how to extract the prices out of the price column for the corresponding date. ex. sheet job bid date bid price 001 6/23/05 $5656 002 6/26/05 $7878 003 7/2/05 $4523 004 6/30/05 $6756 Question: how do I write a function that will look at the jobs in June and take the average of their bid prices, excluding the price of the job in July? "PokerZan" wrote: This really isn't a complete question, so I am assuming all the bids are on a single spreadsheet. If you have all your bid in a column, just go to the last empty cell of said column and enter this: =average(A2:A50) Is this what you are asking? PZan -- PokerZan ------------------------------------------------------------------------ PokerZan's Profile: http://www.excelforum.com/member.php...o&userid=23480 View this thread: http://www.excelforum.com/showthread...hreadid=391432 |
#6
|
|||
|
|||
On Fri, 29 Jul 2005 15:49:03 -0700, "matt"
wrote: What I have is a list of the jobs that we have bid for multiple months on a single spreadsheet. Included in this imformation is a column with the date and a column with the price. What I would like to do is have a function that will return the average bid price for each month. I know how to count the number of bids for each month, but I don't know how to extract the prices out of the price column for the corresponding date. ex. sheet job bid date bid price 001 6/23/05 $5656 002 6/26/05 $7878 003 7/2/05 $4523 004 6/30/05 $6756 Question: how do I write a function that will look at the jobs in June and take the average of their bid prices, excluding the price of the job in July? With some date in June in A1, you could use an array formula: =AVERAGE(IF(MONTH(bid_date)=MONTH(A1),bid_price)) To enter an *array* formula, hold down <ctrl<shift while hitting <enter. In the above formula, you may substitute SUM and/or COUNT for AVERAGE to obtain these other parameters. --ron |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
MSNStockQuote Function Parameters | Excel Worksheet Functions | |||
plotted Average | Charts and Charting in Excel | |||
What is this kind of average called? | Excel Worksheet Functions | |||
average function in Excel 2002 | New Users to Excel | |||
Calculating Net Position and Average Price | Excel Worksheet Functions |