DATABASE FUNDAMENTALS
HOW TO USE THE CONCATENATE FUNCTION IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
=AVERAGE("<100";B2:B100)
|
|
|
=SUMIF(B2:B100;"<100")
|
|
|
=COUNT(B2:B100)
|
|
|
=COUNTIF(B2:B100;"<100")
|
Detailed explanation-1: -In Excel, if you want to count cells that have a value less than or lower than a particular value then you need to use the COUNTIF function. With this function, you can specify a range of values to count and then a criteria number to count the cells less than that.
Detailed explanation-2: -Use the COUNTIF function to count numbers greater than or less than a number. A11 and A12 has formulas where COUNTIF checks for the number of invoices less than 20000 and greater than or equal to 20, 000 in the B2:B7 range. COUNTIF finds 4 values less than 20000 and 2 values greater than and equal to 20000.
Detailed explanation-3: -Use the COUNT function to get the number of entries in a number field that is in a range or array of numbers. For example, you can enter the following formula to count the numbers in the range A1:A20: =COUNT(A1:A20). In this example, if five of the cells in the range contain numbers, the result is 5.
Detailed explanation-4: -Use COUNTIF, one of the statistical functions, to count the number of cells that meet a criterion; for example, to count the number of times a particular city appears in a customer list. In its simplest form, COUNTIF says: =COUNTIF(Where do you want to look?, What do you want to look for?)