How do I use DAverage in Excel?

X

xrayr

I have a spreadsheet with columns of data on sheet 1. I would like to have
the average of column "U" determined ONLY when the corresponding data in
Column "C" equals a certain value (date value shown as: "2005/01/01")

I would like this average shown on another sheet that I have termed "Summary".

I cannot get this to work.

Somebody please help!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

DAverage Function help needed 3
countifs Function not giving desired result with date criteria 2
Help with time function 7
Modify data going to DAverage function 3
Problem using IF statement with dates as part of the formula 4
How to get largest date from a Vlookup 1
AverageIf function with multiple columns 1
Calculating an average of data between two dates 1

Top