Vlookup Avearge same day flow

Hi Everyone,

Wonder if anyone can help with this.... Trying to get an average daily reading from multiple entries on the same day using the V lookup function.
So far the Vlookup is working but it is only picking one value. Is there a way for the function to pick all the entries for the same day and average them ( and disregard the cell with zeros)



Many Thanks

H.B


16/11/2017 0 16/11/2017 7.519999981 0
16/11/2017 0 17/11/2017 7.574999809 0
16/11/2017 7.315000057 18/11/2017 0
16/11/2017 7.519999981 19/11/2017 0
17/11/2017 0 20/11/2017 0
17/11/2017 0 21/11/2017 0
17/11/2017 7.739999771 22/11/2017 0
17/11/2017 0.07 23/11/2017 0
17/11/2017 7.574999809 24/11/2017 0

Hi,

have you tried the =AVERAGEIFS() function? That might be quicker and easier.

Will you please attach a SMALL sample Excel workbook (10-20 rows of data is usually enough)? However, please give us an indication of the approximate number of rows of data you want the solution to work with (100, 1000, 100,000 or whatever). Please don't attach a picture of an Excel sheet (no-one will want to re-type all your stuff before starting).

1. Make sure that your sample data are truly REPRESENTATIVE of your real data. The use of unrepresentative data is very frustrating and can lead to long delays in reaching a solution.

2. Make sure that your desired solution is also shown (mock up the results manually).

3. Make sure that all confidential information is removed first!!

4. Try to avoid using merged cells. They cause lots of problems!

Unfortunately the attachment icon doesn't work at the moment. So, to attach an Excel file you have to do the following: Just before posting, scroll down to Go Advanced and then scroll down to Manage Attachments. Now follow the instructions at the top of that screen.

You attached an xlsx.... so I assume your prfile (Excel 2003) is incorrect. if so, please amend it.

=IFERROR(AVERAGEIFS(B:B,A:A,E2,B:B,">0"),"")

copied down.