Excell average function problem
Closed
viocat
-
Aug 13, 2009 at 05:02 AM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Aug 13, 2009 at 07:01 AM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Aug 13, 2009 at 07:01 AM
Related:
- Excell average function problem
- Mutator function c++ - Guide
- Network card function - Guide
- Find function on mac - Guide
- Hard drive function - Guide
- Spreadsheet function - Guide
1 response
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Aug 13, 2009 at 07:01 AM
Aug 13, 2009 at 07:01 AM
=AVERAGE(IF(ISNUMBER(A1:A7),A1:A7,""))
hit control+shift+enter
A1:a7 is the range where your entries are. modify if necessary
hit control+shift+enter
A1:a7 is the range where your entries are. modify if necessary
