would this (CTRL+SHIFT+ENTER this formula):

=AVERAGE(IF($A3='Bond 1 Analysis (3)'!$A$3:$A$11357,'Bond 1 Analysis
(3)'!$B$3:$B$11357,))

help?

On 18 Mar, 16:09, SK08 wrote:
On Mar 18, 11:05*am, SK08 wrote:

Hi,

Right now I have two sheets, sheet 1 has a list of dates in column A
(each date only listed once). Sheet 2 has individual purchases, with
the dates in column A and the price in column B.

Based on the date (listed in one cell) in sheet 1 i want to find the
average price of all the purchases on that date in sheet 2 (listed in
many cells).

Right now, in sheet 1, cell B3, my formula is :
=AVERAGE(VLOOKUP($A3,'Bond 1 Analysis (3)'!$A$3:$B$11357,2,FALSE))

I am getting a number (not "N/A", etc), but it is different than the
average I got for the date when I did it manually to check.

Clarification: Right now it is only returning the first purchase price
for the date I'm looking up.. How can I get it to continue to search
for that date and average all prices together?