Month: July 2020

C programming tutorials for Beginners – C Multidimensional Arrays

Hits: 21 (C Programming Tutorials) C Multidimensional Arrays In this tutorial, you will learn to work with multidimensional arrays (two-dimensional and three-dimensional arrays) with the help of examples. In C programming, you can create an array of arrays. These arrays are known as multidimensional arrays. For example, float x[3][4]; Here, x is a two-dimensional (2d) array. The …

Excel formula for Beginners – How to Subtotal invoices by age in Excel

Hits: 48    (Excel examples for Beginners) In this end-to-end excel example, you will learn – How to Subtotal invoices by age in Excel.   How to Subtotal invoices by age in Excel Generic formula =SUMIF(age,criteria,amount) Explanation If you need to subtotal invoice amounts by age, you can easily do so with the SUMIF function. …

Excel formula for Beginners – How to Subtotal by invoice number in Excel

Hits: 97  (Excel examples for Beginners) In this end-to-end excel example, you will learn – How to Subtotal by invoice number in Excel.   How to Subtotal by invoice number in Excel Generic formula =IF(COUNTIF(range,criteria)=1,SUMIF(range,criteria,sumrange,””) Explanation To subtotal values by invoice number, you can use a formula based on COUNTIF and SUMIF. In the example …

Excel formula for Beginners – How to Subtotal by category in Excel

Hits: 33    (Excel examples for Beginners) In this end-to-end excel example, you will learn – How to Subtotal by category in Excel.   How to Subtotal by category in Excel Generic formula =SUMIF(color_range,criteria,number_range) Explanation If you need to subtotal numbers by color, you can easily do so with the SUMIF function. In the example …

Excel formula for Beginners – How to Calculate running total in Excel

Hits: 19  (Excel examples for Beginners) In this end-to-end excel example, you will learn – How to Calculate running total in Excel.   How to Calculate running total in Excel Generic formula =SUM($A$1:A1) Explanation To calculate a running total, or cumulative sum, you can use the SUM formula with a mixed reference that creates an expanding range. …

Excel formula for Beginners – How to COUNTIFS with multiple criteria and OR logic in Excel

Hits: 39  (Excel examples for Beginners) In this end-to-end excel example, you will learn – How to COUNTIFS with multiple criteria and OR logic in Excel.   How to COUNTIFS with multiple criteria and OR logic in Excel Generic formula =SUM(COUNTIFS(range,{“red”,”blue”,”green”})) Explanation To count with multiple criteria and OR logic, you can use the COUNTIFS …

Excel formula for Beginners – How to Count unique numeric values in a range in Excel

Hits: 441    (Excel examples for Beginners) In this end-to-end excel example, you will learn – How to Count unique numeric values in a range in Excel.   Free Machine Learning & Data Science Coding Tutorials in Python & R for Beginners. Subscribe @ Western Australian Center for Applied Machine Learning & Data Science. Western …

Excel formula for Beginners – How to Count total matches in two ranges in Excel

Hits: 10    (Excel examples for Beginners) In this end-to-end excel example, you will learn – How to Count total matches in two ranges in Excel.   How to Count total matches in two ranges in Excel Generic formula =SUMPRODUCT(COUNTIF(range1,range2)) Explanation If you want to compare two ranges, and count total matches between the two …

Excel formula for Beginners – How to Count rows with multiple OR criteria in Excel

Hits: 12  (Excel examples for Beginners) In this end-to-end excel example, you will learn – How to Count rows with multiple OR criteria in Excel.   How to Count rows with multiple OR criteria in Excel Generic formula =SUMPRODUCT(–((criteria1)+(criteria2)>0)) Explanation To count rows using multiple criteria across different columns – with OR logic – you can use the SUMPRODUCT …