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: Jan 22, 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...Read More
 

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.