Which formula can add the all the numeric values in a range of cells, - ProProfs Discuss
Topics
Products
Follow Us:

Which formula can add the all the numeric values in a range of cells, ignoring those which are not numeric, and place the result in a different cell?

Which formula can add the all the numeric values in a range of cells, ignoring those which are not numeric, and place the result in a different cell?

Change Image    Delete



A. Count
B. Average
C. Sum

This question is part of MICROSOFT EXCEL EXAM
Asked by Wyatt Williams, Last updated: Mar 30, 2020

+ Answer
Request
1

4 Answers

Anika Nicole

Content Writer, Teacher

Anika Nicole, Wordsmith, PG In Journalism, New York

Answered Jun 05, 2018

The formula which can add the all the numeric values in a range of cells, ignoring those which are not numeric, and place the result in a different cell is "Sum". So, the correct answer is option C.

In MS-Excel, the alphanumeric values are ignored during a calculation. You need write only "SUM" and the range of the cells within brackets. Basically, this function adds the numbers of the cells and return the result. It is a built-in function and its category isMath/Trig Function.

Syntax of the SUM function:

SUM( number1, [number2, ... number_n] )

OR

SUM ( cell1:cell2, [cell3:cell4], ... )

 

John Adney

John Adney

Answered May 15, 2017

Boiiiii this stuff sucks a lot of bull crap so0rry
 

engmaroof

Engmaroof

Answered May 06, 2017

SumWhich formula can add the all the numeric valuesin a range of cells, ignoring those which are not numeric, and place the resultin a different cell ?
 

John Smith

John Smith

Answered Oct 28, 2016

Sum
 

Search for Google images
Select a recommended image
Upload from your computer
Search for Google images
Select a recommended image
Upload from your computer
Search for Google images
Select a recommended image
Upload from your computer

Email Sent
We have sent an email to your address "" with instructions to reset your password.