if i need the average of d2 thru d52... can i type in
=AVERAGE(D2 : D25)?
=AVERAGE(D2 : D25)?
-
Last edited by SIGSays; 03-30-2004, 07:02 PM.My PBR Feedback
My AO Feedback
My PBN Feedback
NEED A Y/I-FRAME, XVALVE OR ANY NEW AGD PRODUCT FOR A VERY REASONABLE PRICE? CONTACT: RogueFactor on AIM!
PURE PWNAGE!
-
that's the proper syntax for adding all of the values.
if you want an average, use =AVERAGE(cell1:cell2)
-
cell 1 being the first cell
and cell 2 being the last cell.. with all the cells inbetween too right?
the error was it showed a blue diamond and 0
THANX manMy PBR Feedback
My AO Feedback
My PBN Feedback
NEED A Y/I-FRAME, XVALVE OR ANY NEW AGD PRODUCT FOR A VERY REASONABLE PRICE? CONTACT: RogueFactor on AIM!
PURE PWNAGE!
Comment
Comment