Learn with Manish Shori

  Excel COUNTIF function Excel COUNTIF function - count cells that meet one condition The COUNTIF function is purposed for counting cells that meet a certain criterion. Its syntax requires 2 arguments which are self explanatory. COUNTIF (range, criteria) In the first argument, you define a range where you want to count cells and in the second parameter, you specify a condition that should be met. For example, to count how many cells in range A2:A17 is "car", you use the following COUNTIF formula:   =COUNTIF(A2:A17, "car") Instead if typing a criterion directly in the formula, you can input a cell reference as demonstrated in the following screenshot: Excel COUNTIFS function - count cells that match several criteria The COUNTIFS function is similar to COUNTIF but it allows specifying multiple ranges and multiple criteria. Its syntax is as follows: COUNTIFS (criteria_range1, criteria1, [criteria_range2, criteria2]…) For example, to count how many "cars"

  Introduction to company creation The first and foremost thing to do when we start accounting with tally is to know how to create a company in Tally ERP 9. Today one can operate Tally remotely using Tally.net features, process payroll and many more features are updating regularly by Tally solutions. The most recent improvement is GST with compatibility from version Tally.ERP 9. Create Company in Tally In this section, we will learn how to create a company using a simple step by step methods. The first step to get started is to create a company. In Tally, the creation of a company involves basic information about the company, books and details of currency. How to create a company in Tally In tally, after login double click on the create company option under company information. The following navigation path is used to create the company in Tally: Go to Gateway of Tally then press Alt+F3 or click on   Cmp Info (company Info) then press C or click on Create Company The compa

  Excel COUNT Function Summary The Excel COUNT function returns the count of values that are numbers generally cells that contain numbers. Values can be supplied as constants, cell references or ranges.  Purpose Count numbers Return value Count of numeric values Syntax =COUNT (value1, [value2], ...) Arguments • value1 - An item, cell reference or range. • value2 - [optional] An item, cell reference or range. Usage notes The COUNT function returns the count of numeric values in the list of supplied arguments. Arguments can be individual items, cell references or ranges up to a total of 255 arguments. All numbers including negative values, percentages, dates, fractions and time are counted. Empty cells and text values are ignored. The result will be   First cell will be ignored because first cell contains text value and COUNT function does not count text, it only counts number. This function also ignore Blank cells The example below shows COUNT with 4 values. Three of