If you’re a daily person of Excel, you then most likely are used to Excel performing calculations with numbers, however in relation to Excel formulation we aren’t restricted to only numbers, it’s going to additionally carry out calculations with different kinds of info. 몸캠피싱 사기

A type of such calculations is the COUNTA operate.

The COUNTA operate can be utilized within the following variations of Microsoft Excel:

  • Excel 2013, Excel 2011 for Mac, Excel 2010, Excel 2007, Excel 2003, Excel XP, Excel 2000

It’s a actually helpful little formulation to have at hand. So what does it’s precisely do?.

It merely counts how most of the cells in your chosen vary include information. Or in different phrases it seems for and counts the quantity on non clean cells within the vary of cells you specify. It shouldn’t be confused with the COUNT operate which is able to rely the variety of numeric values (for instance numbers or dates) inside a provided set of cells or values.

The syntax of this formulation is

=COUNTA(argument1, [argument2,… argument_n] )

the place argument1, argument2,… argument_n are both ranges of cells or values. There may be as much as 30 arguments in Excel 2003, however in Excel 2007 onwards you may enter as much as 225 worth arguments in your formulation. Word that, if a cell comprises an empty textual content string or a formulation that returns an empty textual content string, this cell is counted as a non-blank by the Counta operate.

So, let’s discover an instance of how you possibly can use this formulation.