Monday, 18 December 2017

sumifs


Through the formula of sumifs we can find the sum with the condition.


For Example we have 5 Sales men and we want to find that how much product sale by each sales men. So we can easliy find.

Syntex__ =sumifs(sum range,criteria_range1, criteria1, creiteria_range2,cretria2)

Sum_range          =  Select the sum range
Creteria_range1  = is select the range First column 
Criteria 1             = Slect the name which you find
Cretria_range2    = Select the range Second column
Cretria2               =Select the product you want to find






When you will change the salesmen name (where you apply the formula) it will show you the total sale of that particular salesmen.
at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

calculation of professional tax

Normally professional tax in not applicable all over the country but there are some state where the government take professional tax  Karn...

  • shortcut of tally
    Hello Friends here some shortcut key of tally.   1.          F1                            To select a Company 2.          Alt+...
  • How to prepair Bank Reconcilition Statement
     Bank Reconciliation statement if we say in simple word this is the one way to know that how much balance is in our Company  Account h...
  • PMT formula
    Basically PMT formula is use to calucalt the amount of loan.We will try to uderstand the formula throgh the Example.  Suppose we have ta...