Now, (after vacations), we have been learning those  functions :, counta, countif,sum,countifs, sumif, sumifs

   What can one do with this functions and how to use them.

How to use them is next of the name from the function, and then what can one do.

counta: =counta(range ; criterium) To see how many cells from where are empty/ full, or have numbers(dates are stored as numbers)

countif : =countif(range ; criterium)  To see how many cells you selected complain a characterist.

sumif: =sumif( Range; criterium ; how many) The same as countif, but you can see the sum of numbers from the column you selected as “how many” that  coincide with “what”.

countifs : =countifs(range; criterium; range; criterium) The same as countif, but you can see how many times the column you selected(where) has a “what” wich coincide with the other “what” from the other column (where)

sumifs:=sumifs(range ; criterium;range; criterium;how many) You can see the sum of the numbers of the column you selected as “how many” that coincide with both “what” from both “where”.