M
matt
I need a function that will return the average for the total bids in an
idividual month.
idividual month.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
P
PokerZan
This really isn't a complete question, so I am assuming all the bids ar
on a single spreadsheet.
If you have all your bid in a column, just go to the last empty cell o
said column and enter this:
=average(A2:A50)
Is this what you are asking?
PZa
on a single spreadsheet.
If you have all your bid in a column, just go to the last empty cell o
said column and enter this:
=average(A2:A50)
Is this what you are asking?
PZa
M
matt
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?
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?
R
Roger Govier
One way
=SUMPRODUCT(--(MONTH($B$2:$B$1000)=6),$C$"2$C$1000)
Change ranges to suit
=SUMPRODUCT(--(MONTH($B$2:$B$1000)=6),$C$"2$C$1000)
Change ranges to suit
R
Roger Govier
Sorry, getting tired and clumsy fingers. That should read
=SUMPRODUCT(--(MONTH($B$2:$B$1000)=6),$C$2:$C$1000)
Change ranges to suit
=SUMPRODUCT(--(MONTH($B$2:$B$1000)=6),$C$2:$C$1000)
Change ranges to suit
R
Ron Rosenfeld
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