What is an array in Excel?

Basically, an array is a set of items. The items can be text or numbers and they can occupy in a single row or column, or in multiple rows and columns. An array is only a list or range of values. What is an array formula in Excel? Array formulas in Excel are a very powerful tool and difficult… Continue reading What is an array in Excel?

Understanding conditional formatting .

Conditional formatting is a feature in various spreadsheet applications that permits you to apply specific formatting to cells that meet certain criteria or specified condition. It is mostly used as a color-based formatting to highlight, emphasize or differentiate among statistics and information stored in a spreadsheet. Conditional formatting makes it easy to highlight interesting cells (ranges of… Continue reading Understanding conditional formatting .

How to use the SUMIF Function

You operate the SUMIF function to sum the values in a range that meet criteria that you specify. SUMIF is the function used to sum the values according to a single criterion. Using this function, you can locate the sum of numbers applying a condition within a range. It comes beneath Math & Trigonometry capabilities. Just… Continue reading How to use the SUMIF Function