Function SUMIF adds cells specified by a given condition or criteria. Syntax of function SUMIF is =SUMIF (range, criteria, [sum_range]) Where range is the range of the array from where the criteria will be matched. [sum_range] is the range from where the …
HLOOKUP is a function that looks for a value in the top rows of a table or array and returns the value in the same column from a row you specify. It is nothing but another function for looking up …
Lesson#11: How to use the HLOOKUP function in Excel? Read more »
In this post function, VLOOKUP is explained here once more with a very simple example. VLOOKUP looks for the value in the leftmost column of a table. It means the lookup_value column should be placed on the right side of …
In our 8th lesson, I will discuss COUNT, COUNTIF, and the combination of IF and COUNTIF. COUNT is a function that counts the number of cells in a range that contains a number. I have given an example of COUNT …
Lesson#8: COUNT, COUNTIF, and combination of IF and COUNTIF Read more »
In this post we will discuss nested IF making. I have to show Grade on the mark sheet so I will check multiple conditions by IF. The structure of nested IF will be like this =IF(E5<85,IF(E5<70,IF(E5<55,IF(E5<40, IF(E5<25, “F”, “E”), “D”), “C”), …
In this post, we will discuss function IF. IF is a logical function that checks whether a condition is met and then returns a value if TRUE or another value if FALSE. Syntax of function IF is =IF(logic_test, value_if true, …
In this post, we will learn a very useful function, VLOOKUP (Vertical Lookup, or value lookup in columns), by which we can easily find data within a table. I have madea Data Validation (List) within a cell, which shows the …
We made a table of mark sheets in the previous post; now we will learn something new. We will learn to show percentages, the function MAX, and the function MIN I have added columns on the right-hand side and put …
Lesson#3: Showing percentage, learning function MAX, function MIN Read more »
We will learn how to make a table with a simple mark-sheet example, and we will learn the Excel SUM and AVERAGE functions. This is a table I have made. On the left side, there are names of students, on …
Lesson#2: Making and formatting table, SUM function, and AVERAGE functions Read more »
OK friends. This is going to be my first lesson. The ABCD of Excel starts here. We will learn how to perform basic operations in Excel. How to add, subtract, multiply, and divide two numbers. This picture now shows how …