Google Sheets SUMIFS and SUMIF with multiple criteria – formula examples

Google Sheets SUMIFS and SUMIF functions also present in Microsoft Excel for doing conditional sum based on single or multiple criteria only. Is very helpful in doing conditional sums and that is the objective of out tutorial today. So, we have the data i.e. first table as shown below: And our target is to fill … Read more Google Sheets SUMIFS and SUMIF with multiple criteria – formula examples

How to Create and Edit Spreadsheets for Free with Google Sheets

What is Google Sheets and how to create and edit spreadsheets for free with Google Sheets? A free web based program to create and edit spreadsheets, powerpoint presentations and word documents just like Microsoft Excel.  As can be seen from the above image it has option to upload file or folder. Also, we can create … Read more How to Create and Edit Spreadsheets for Free with Google Sheets

How to use VLOOKUP in Microsoft Excel / Googlesheets – Spreadsheet Skills

VLOOKUP in Microsoft Excel / Googlesheets – Spreadsheet is a very useful function to map data from multiple tables into one and hence helping effective visualization and is very important from analysis point of view. Objective: Using the VLOOKUP function available in Google Sheet / Microsoft Excel and merging multiple tables into one. Table A: … Read more How to use VLOOKUP in Microsoft Excel / Googlesheets – Spreadsheet Skills