Excell average function problem
Closed
viocat
-
Aug 13, 2009 at 05:02 AM
venkat1926 Posts 1864 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Aug 13, 2009 at 07:01 AM
venkat1926 Posts 1864 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
- Function key stuck on - Guide
- Function of spreadsheet - Guide
- Print function excel ✓ - Excel Forum
- Is not accessible incorrect function - Pen Drive, USB & SD Card Forum
- Wifi function - Guide
1 reply
venkat1926
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
810
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