Use vlookup to find the dates and then average the values in corresponding column

**ash369ster** · 07-02-2015, 11:17 PM

Hello! i have a spreadsheet with dates in column A.

In column C, i have values.

What i want to do is find average of the values in column C when i key in a period (3/5/2015 to 3/7/205), it gives me average of the values in column C for that period.

The issues i am unable to solve are: sometimes column A may have the same data twice, and column C may not may not have values corresponding to that date. i tried using Index and row formula but it is not working.

Any help is appreciated

Thank you!

**NeedForExcel** · 07-02-2015, 11:28 PM

Try using SUMIFS..

Something like

=SUMIFS(C:C,A:A,">="&E2,A:A,"<="&F2)

Where E2 has FROM Date & F2 has To Date.

See the attached file if needed

**ash369ster** · 07-02-2015, 11:46 PM

OMG! lifesaver! thank you!

**NeedForExcel** · 07-03-2015, 12:09 AM

Glad it helped..

Use vlookup to find the dates and then average the values in corresponding column

LinkBack

Thread Tools

Rate This Thread

Display

Use vlookup to find the dates and then average the values in corresponding column

Re: Use vlookup to find the dates and then average the values in corresponding column

Re: Use vlookup to find the dates and then average the values in corresponding column

Re: Use vlookup to find the dates and then average the values in corresponding column

Thread Information

Users Browsing this Thread

Similar Threads

How to vlookup for a single column to find duplicate values

How to find single average the values datewise which has random dates?

[SOLVED] Find average of lowest 5 values in a column

for each value of Column A, To find the average of values of column C

Dates in Column A, Values in Column B, Find Certain Value

Bookmarks

Bookmarks

Posting Permissions