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

J

Jayzer

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?
 
W

Wayne Morgan

Please scroll down the alphabetical list of newsgroups to find an Excel
newsgroup. This one is for the Access Database program.
 
S

SteveV

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
Finding the proper style field and the numbered paragraph value within the style 0
Finding the right style field in VBA 0
Linking Child Timelines to Multiple Parents 0
Count Query 2
Synchronization problems while moving folders to new email 1
averaging info from three columns 5
How do I add a break after each subtotal? 1

Top