Bdmedia Excel function

Asked

Viewed 50 times

0

If I run the Bdmedia function in a table column containing text, it will enter as count on average?

For example, in a column with 10 dice, being 9 numbers and 1 text, it will divide the sum of the values by 9 or 10?

excel

2 answers

0

If I understood correctly, for it to work the formula Bdmedia, in the column of values it will make the media according to the criteria of the filters =Bdmedia(banco_de_data; field; criteria) "criterios", if an example Voce determines the filters, but in the value fields is some text probably the formula will give error in the calculation;

0

The function BDMÉDIA has the following parameters:

                       `BDMÉDIA(banco de dados, campo, critérios)`
  • In the parameter banco de dados, the first line has the labels of your columns.
  • The parameter campo handles column position in database whole by label name or column number.
  • In turn, the parameter critério is where the user can create any range of argument, provided that it refers to a label of column and a cell below it as condition.

So, if any text is written in a column with numerical values, the combination of a function SE with the function ÉTEXTO would solve your problem.

Browser other questions tagged excel

You are not signed in. Login or sign up in order to post.