## In Excel, How to sum only positive or Negative numbers – Formula

When working with Excel datasheets, you may often need to conditional add the data. You may need to sum only the positive numbers or sum only the negative numbers in Excel. It can easily be done using the built-in formulas within Excel. Below, we guide you on how to do this. Let's look at the

## How to Hide Formulas in Excel

It is easy to get formulas in Excel; by clicking on the cell or, rather, by selecting the Formulas ribbon. It gives you the formula you are looking for and the step-by-step evaluation walkthrough of the formula. However, when you are working on complex calculations, it is important to hide the formulas to avoid cluttering

## How to make y=mx+c in Excel

A linear equation in mathematical subjects usually produces a line graph when mapped on a spreadsheet. The equation takes the form y = MX + b, where m is the gradient of the line and b is the y-intercept. In this case, C can also apply. Microsoft Excel cannot draw linear equations directly; in order

## How to generate random numbers in Excel

Random numbers are automated generated numbers that are displayed without an order. When working on a worksheet, the user may need to generate random numbers to perform various tasks. This is achievable due to the existence of two worksheet functions that are responsible for generating random numbers. They include The RAND function and the RANDBETWEEN

## How to prevent Excel from rounding off numbers

Microsoft has designed excel in a way that will be efficient and easy to use for its users. However, some of the features of Excel can be counterproductive and thus reducing its efficiency. Rounding off large numbers is one of these features that are times counterproductive. When dealing with large numbers on excel cells, excel

## How to combine data from 3 cells into one

At times we work with large worksheets in an Excel workbook. It becomes a dreaded issue when you want to combine all your data, as most people automatically think it will mean retyping all that text. Now you can breathe a sigh of relief because, when you are working with data in Excel, it is

## How to count cells that contain only N character

Excel is a powerful and very helpful Microsoft program for data analysis and documentation. OK is a spreadsheet program with many columns and rows, and sometimes we need to know the number of cells and the number of columns or characters within the cell. As we all know, every cell contains one point of data

## How to Remove Characters in Excel Cells

Formulas are key in getting things done in excel. One can apply formulas to manipulate texts, work with dates and time, count and sum with criteria, create dynamic ranges, and dynamically rank values. Explained below are formulas one can apply to remove characters in excel cells. 1. The Array Formula Assuming we want to eliminate

## Excel formula for percentage

Anyone who constantly works with numbers probably also works with percentages. Calculating percentages apply in many areas of our day-to-day and everyday lives. Some of the areas we apply percentages include; discounts, percentage changes between different values, and percentage of correct answers in a test or survey. Lucky enough, it is easier to calculate percentages.

## How to Add Odd Numbers Only in Range

If you have a worksheet full of odd numbers and you want to add them, you can use this formula to get their sum. The formula {=SUM(Range*(MOD(Range,2)=1))} Do not type out of the brackets. Hold CTRL+shift, then press Enter while still in edit mode to create an array formula. RANGE= is the range of values