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 …

# Month: July 2020

Hits: 28 (C Programming Tutorials) C Arrays In this tutorial, you will learn to work with arrays. You will learn to declare, initialize and access elements of an array with the help of examples. An array is a variable that can store multiple values. For example, if you want to store 100 integers, you can …

Hits: 12 (C Programming Tutorials) C Storage Class In this tutorial, you will learn about scope and lifetime of local and global variables. Also, you will learn about static and register variables. Every variable in C programming has two properties: type and storage class. Type refers to the data type of a variable. And, storage …

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. …

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 …

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 …

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. …

Hits: 31 (C Programming Tutorials) C Recursion In this tutorial, you will learn to write recursive functions in C programming with the help of an example. A function that calls itself is known as a recursive function. And, this technique is known as recursion. How recursion works? void recurse() { … .. … recurse(); … …

Hits: 11 (C Programming Tutorials) Types of User-defined Functions in C Programming In this tutorial, you will learn about different approaches you can take to solve the same problem using functions. These 4 programs below check whether the integer entered by the user is a prime number or not. The output of all these programs …

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 …

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 …

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 …

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 …

Hits: 17 (C Programming Tutorials) C User-defined functions In this tutorial, you will learn to create user-defined functions in C programming with the help of an example. A function is a block of code that performs a specific task. C allows you to define functions according to your need. These functions are known as user-defined …

Hits: 14 (C Programming Tutorials) C Functions In this tutorial, you will be introduced to functions (both user-defined and standard library functions) in C programming. Also, you will learn why functions are used in programming. A function is a block of code that performs a specific task. Suppose, you need to create a program to …