Sumif Function is used when calculate sum of the specific a limited criteria of the data. For Example we have a data from 1 to 10 and we want sum of the number which are less than five then sumif ignores the other numbers whi…
Average function is used to find the mean value of given data. It can be count up to the 255 arguments. It can calculate numbers, cell references, arrays. Syntax For AVERAGE Function =AVERAGE(Number1, Number2,....) Wh…
The sum function is very useful in excel. It will give you the sum of the 1 st cell to 255 th cell. Lets we see basic Sum Function The sum is to add values. You can add two values and more than two values…
