+ Reply to Thread
Results 1 to 4 of 4

DAverage formula help

  1. #1
    Registered User
    Join Date
    01-29-2016
    Location
    Vancouver, Canada
    MS-Off Ver
    2013
    Posts
    19

    DAverage formula help

    I'm having problems trying to get the daverage formula to work.

    In cells n10:n11, I'm supposed to use the DAVERAGE function.

    In the new output area, Grade A includes all students whose grade is A+, A, or A-, Grade B includes all students whose grade is B+, B, or B-.

    I've been writing the formula as =daverage(a2:h12,"scholarship_amount",m2:m4), but when I press ENTER, I keep getting #VALUE!

    I feel like I'm missing something basic.

    Any ideas on what I'm doing wrong?
    Attached Files Attached Files
    Last edited by musicgirl; 03-11-2016 at 11:06 PM.

  2. #2
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Re: DAverage formula help

    try:
    1.
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    2.
    Formula: copy to clipboard
    Please Login or Register  to view this content.


    your formula: =daverage(a2:h12,"scholarship_amount",m2:m4)
    m2:m4 has no label, should be m1:m4
    "scholarship_amount" - this is different then
    "Scholarship
    Amount"
    because there is no underscore but exist space and CHAR(10). Better use column number. In this case: 6
    Last edited by sandy666; 03-11-2016 at 10:05 PM. Reason: typo

  3. #3
    Registered User
    Join Date
    01-29-2016
    Location
    Vancouver, Canada
    MS-Off Ver
    2013
    Posts
    19

    Re: DAverage formula help

    Thanks. That helped a lot!

  4. #4
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Re: DAverage formula help

    You are welcome. Glad to help

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] DAVERAGE With criteria within the formula
    By Kalvas in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 02-01-2016, 08:24 AM
  2. [SOLVED] Ignoring errors in DAVERAGE formula
    By Lharbicht in forum Excel General
    Replies: 11
    Last Post: 06-10-2014, 06:57 PM
  3. [SOLVED] Daverage
    By nir020 in forum Excel General
    Replies: 9
    Last Post: 11-01-2005, 04:09 PM
  4. [SOLVED] How do I use DAverage in Excel?
    By Roger Govier in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 09-06-2005, 06:05 PM
  5. [SOLVED] How do I use DAverage in Excel?
    By xrayr in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 10:05 AM
  6. How do I use DAverage in Excel?
    By xrayr in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 07:05 AM
  7. daverage problems
    By Jay in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-06-2005, 01:05 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1