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.

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

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

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

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

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