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