If i want to Count the number of cells that contain numerical values *What is the excel formula to be used

Database System Concepts
7th Edition
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Chapter1: Introduction
Section: Chapter Questions
Problem 1PE
icon
Related questions
Question
If i want to Count the number of cells that contain numerical values *What is the excel formula to be used? 
AutoSave
Off
File
Home
Insert
Draw
Page Layout
Formulas
Data
Review
View
X Cut
Calibri
11
A
A
B Copy
Paste
BIU
A
Format Painter
Clipboard
Font
Alic
SUM
fx
=AVERAGE(B2:B11)
A
В
C
1
Country
Population
2 China
1,389,618,778
3 India
1,311,559,204
4 USA
331,883,986
5 Indonesia
264,935,824
6 Pakistan
210,797,836
7 Brazil
210,301,591
8 Nigeria
208,679,114
9 Bangladesh
161,062,905
10 Russia
141,944,641
11 Mexico
127,318,112
12 Average
=AVERAGE(B2:B11) Output = 435,810,199
13
14
lili
Transcribed Image Text:AutoSave Off File Home Insert Draw Page Layout Formulas Data Review View X Cut Calibri 11 A A B Copy Paste BIU A Format Painter Clipboard Font Alic SUM fx =AVERAGE(B2:B11) A В C 1 Country Population 2 China 1,389,618,778 3 India 1,311,559,204 4 USA 331,883,986 5 Indonesia 264,935,824 6 Pakistan 210,797,836 7 Brazil 210,301,591 8 Nigeria 208,679,114 9 Bangladesh 161,062,905 10 Russia 141,944,641 11 Mexico 127,318,112 12 Average =AVERAGE(B2:B11) Output = 435,810,199 13 14 lili
Expert Solution
steps

Step by step

Solved in 2 steps

Blurred answer
Knowledge Booster
Keywords
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Recommended textbooks for you
Database System Concepts
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education