How can i do a range (>10,<20) in DAVERAGE (Excel)?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

In the example given for DAVERAGE it shows trees <10 feet tall. How can I
get an average "profit" for trees between 10' and 20' only?
 
Please scroll down the alphabetical list of newsgroups to find an Excel
newsgroup. This one is for the Access Database program.
 
You could make a column next to the tree height and put this in
=IF(AND(A1>10,A1<20),1,0) then do a Average at the bottom of that column.
Set the cell to percentage.
 

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 worksheet function 1
Reference cell values from other sheets in a function 2
Why do I get 0.00 for "" in a formula? 1
averaging info from three columns 5
A Tree 5
Count Query 2
DAVERAGE, DMIN,etc from List 1
DAVERAGE isn't working 4

Back
Top