How to use INDEX Function | Excel, Google Sheets | Easy Visual Guide

how to use index function

Index function in Excel comes from lookup and reference function family. These functions are equally available in Excel, Google Sheets and Open Office Spreadsheet software. This article covers most of the aspects for powerful use and application of index() function in your worksheets. If you are just interested in referring to the format and parameters … Read more

How to Use SUMIF Function | Excel, Google Sheets | 9 Easy Examples

How to use sumif function in excel

SUMIF function is most frequently used for data processing in the spreadsheets. This article is primarily written for the users to use the conditional sum function in the Excel as well as Google Spreadsheet programs more proficiently. The article focuses on the introduction to simple sum function, the conditional sum function sumif(), the explanation of … Read more