Which formula would you use to add the all the numeric data in a - ProProfs Discuss
Menu
SearchAsk a Question+ Ask Question
Advertisement
  1. Microsoft Office
  2. Microsoft Excel

Which formula would you use to add the all the numeric data in a range of cells, ignoring those which are not numeric in MS-Excel?

Which formula would you use to add the all the numeric data in a range of cells, ignoring those which are not numeric in MS-Excel?

Change Image    Delete

Also, you have to place the result in a different cell.

Asked by PRST_GY, Last updated: Jan 06, 2025

+ Answer
Request
Share
Question menu
Vote up Vote down

1 Answer

PRST_GY

PRST_GY

PRST_GY
PRST_GY

Answered Sep 07, 2019

Sum
upvote downvote
Reply 

More Microsoft Excel Questions

Ask Your Own Question

Can You Answer

Advertisement
Advertisement
Search for Google images Google Image Icon
Select a recommended image
Upload from your computer Loader
CancelLoader
Image Preview
Search for Google images Google Image Icon
Select a recommended image
Upload from your computer Loader
CancelLoader
Image Preview
Search for Google images Google Image Icon
Select a recommended image
Upload from your computer Loader
CancelLoader

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