Sumifs

                                                    Use Of Sumifs

Sumifs is the conditional formula. This is the fantastic formula in excel when we have data in bulk and we have to find out the result with multiple comdition. As the name of the fourmula is SUMIFS (sum+ifs). We use this function in when we want to sum.

For Example:- we have some salesman and we want to find out that how much they did sale in the particular period by each sales man.

Syntex:-  sumifs(Sum range, Criteria_range1,criteria_range1,Criteria_range2,criteria_range2)

Sum range:- The actual cellto add, if you want to add other than those specified in the range argument.

Range Required:- The range of the cells that you want evaluated by criteria, the range must be number, names or array or reference that contain numbers.

Criteria Required:- The criteria is in the form of number, expression a cell reference, text or a function that define which cell will be added.

Sum range       =  The range to be sum

Range1                =  The first range to evaluate.  

Criteria 1             = The criteria to use on range1

Range2                = The second range to evaluate

Cretria2               =The criteria to use on range2

write here salesman and the model of mobile. You can see the result in the next image. if you want to apply the formula in next cell copy the formula and paste in next cell or drag down the formula.

Ledger and Group

                                Tally Ledger and their Group

When we create ledger in tally so they have their groups. like we saprate all the ledger by their group so that all type of expense and income will be together. All income will lo income group and the expenses will go with Expense group. It is the way to saprate the income and the expenses.

Accounts Name	Groups
Cash	Cash in Hand
Bank Overdraft	Bank OD
Bombay Branch	Branch & Division
Delhi Branch	Branch & Division
Capital	Capital Account
Drawing	Capital Account
House Rent	Capital Account
Income Tax	Capital Account
LIC Premium (Dr)	Capital Account
LIC Refund (Cr)	Capital Account
Life Insurance	Capital Account
Personal Expenses	Capital Account
Current Assets
Accrued Income	Current Assets
Accrued Rent/ Accrued Income	Current Assets
Bills Receivable	Current Assets
Bonds	Current Assets
Consignment Stock	Current Assets
Deferred Expenses	Current Assets
FDR	Current Assets
Hundi (Assets)	Current Assets
Prepaid Expenses	Current Assets
Stock of Material	Current Assets
Current Liabilities
Advertisement Payable	Current Liabilities
Bills Payable	Current Liabilities
Deferred Income	Current Liabilities
Depreciation Reserve	Current Liabilities
General Reserve	Current Liabilities
Hundi (Liability)	Current Liabilities
Outstanding Expenses	Current Liabilities
Provision for Office Expenses	Current Liabilities
Rent Payable	Current Liabilities
Salary Payable	Current Liabilities
Tea Exp. Payable	Current Liabilities
Unearned Income	Current Liabilities
VAT Payable	Current Liabilities
Direct Expenses
Carriage	Direct Expenses
Coal & Fuel	Direct Expenses
Coal, Gas & Water of Factory	Direct Expenses
Consumed Material	Direct Expenses
Coolage	Direct Expenses
Expenses on Purchases	Direct Expenses
Factory Expenses (Lighting, Power etc.)	Direct Expenses
Freight	Direct Expenses
Freight Inward	Direct Expenses
Freight on Purchase (Freight Inward)	Direct Expenses
Fuel & Power of Factory	Direct Expenses
Gas and Water	Direct Expenses
Import Duty	Direct Expenses
Manufacturing Expenses	Direct Expenses
Octroi	Direct Expenses
Oil	Direct Expenses
Power & Fuel	Direct Expenses
Production Wages	Direct Expenses
Rent on Purchase	Direct Expenses
Train Freight & Rent	Direct Expenses
Wages	Direct Expenses
Wages on Production	Direct Expenses
Direct Incomes
Apprentice Premium	Direct Incomes
Factory Incomes	Direct Incomes
Input CGST, SGST, IGST	Duties & Taxes
Output CGST, SGST, IGST	Duties & Taxes
Fixed Assets
Air Conditioner	Fixed Assets
Building	Fixed Assets
Car	Fixed Assets
Computer	Fixed Assets
Factory	Fixed Assets
Farm House	Fixed Assets
Furniture & Fitting	Fixed Assets
Furniture & Fixture	Fixed Assets
Goodwill	Fixed Assets
Horse & Carts	Fixed Assets
Land & Building	Fixed Assets
Loose Tools	Fixed Assets
Machine & Tools	Fixed Assets
Motor Cycle	Fixed Assets
Plant & Machine	Fixed Assets
Purchase of New Land	Fixed Assets
Refrigerator	Fixed Assets
Scooter	Fixed Assets
Shop	Fixed Assets
Showroom / Shop	Fixed Assets
Typewriter	Fixed Assets
Indirect Expenses
Advertisement Expenses	Indirect Expenses
Audit Fees	Indirect Expenses
Bad Debts	Indirect Expenses
Bank Commission	Indirect Expenses
Car Expenses	Indirect Expenses
Car Repair	Indirect Expenses
Carriage on Sales	Indirect Expenses
Coffee Expenses	Indirect Expenses
Coke Expenses	Indirect Expenses
Commission (Dr.)	Indirect Expenses
Depreciation	Indirect Expenses
Discount (Dr) / Discount Allowed	Indirect Expenses
Donation	Indirect Expenses
Electricity Expenses	Indirect Expenses
Expenses on Sales	Indirect Expenses
Export Duty	Indirect Expenses
Fire Insurance	Indirect Expenses
Forex Gain Loss	Indirect Expenses
Freight on Sale (Freight Outward)	Indirect Expenses
Freight Outward	Indirect Expenses
General Expenses	Indirect Expenses
Godown Rent	Indirect Expenses
Insurance	Indirect Expenses
Interest (Dr.)	Indirect Expenses
Interest on Capital	Indirect Expenses
Interest on Loan	Indirect Expenses
Labour Charges	Indirect Expenses
Legal Expenses	Indirect Expenses
Loss By Damage	Indirect Expenses
Loss by Fire	Indirect Expenses
Loss in Transit	Indirect Expenses
Loss on Assets	Indirect Expenses
Loss on Joint Venture	Indirect Expenses
Machine Repair	Indirect Expenses
Manager’s Commission	Indirect Expenses
Miscellaneous Expenses	Indirect Expenses
Motor Cycle Repair	Indirect Expenses
Office Expenses	Indirect Expenses
Packing Exp.	Indirect Expenses
Pan and Tea Expenses	Indirect Expenses
Petrol Expenses	Indirect Expenses
Postage & Telegram	Indirect Expenses
Printing & Advertisement	Indirect Expenses
Printing & Stationery	Indirect Expenses
Printing, Papers & Advertisement	Indirect Expenses
Provision for Bad Debts	Indirect Expenses
Provision for Discount on Debtors	Indirect Expenses
Rates & Taxes	Indirect Expenses
Refreshment Expenses	Indirect Expenses
Rent	Indirect Expenses
Rent & Tax	Indirect Expenses
Repair & Renovation	Indirect Expenses
Salary	Indirect Expenses
Salary & Wages	Indirect Expenses
Shop Expenses	Indirect Expenses
Shop Rent	Indirect Expenses
Showroom Repair	Indirect Expenses
Stable Expenses	Indirect Expenses
Stamp & Postage	Indirect Expenses
Stationery	Indirect Expenses
Tea or Coffee Expenses	Indirect Expenses
Telephone Expenses	Indirect Expenses
Telephone Securities	Indirect Expenses
Trade Expenses	Indirect Expenses
Travelling Expenses	Indirect Expenses
Vehicle Repair	Indirect Expenses
Indirect income
Fitting Charges Received	Indirect Incomes
Bad Debts Received	Indirect Incomes
Bad Debts Reserve (last year balance)	Indirect Incomes
Commission (Cr.) / Commission Received	Indirect Incomes
Discount (Cr.) / Discount Received	Indirect Incomes
Income From Repair	Indirect Incomes
Income on Assets	Indirect Incomes
Income on Investments	Indirect Incomes
Insurance Claim	Indirect Incomes
Interest on Drawing	Indirect Incomes
Interest Received (Cr.)	Indirect Incomes
Miscellaneous Income	Indirect Incomes
Profit on Consignment	Indirect Incomes
Profit on Jointventure	Indirect Incomes
Provision for Discount on Creditors	Indirect Incomes
Rent Received	Indirect Incomes
Repairing Charges Received	Indirect Incomes
Investment
Invest in Govt. Bond	Investment
Investment	Investment
Master Plus	Investment
Mutual Fund	Investment
Shares / Bonds	Investment
Loans & Liabilities
Bank Loan	Loans & Liabilities
Loan on Mortgage, Loans	Loans & Liabilities
Purchase	Purchase Account
Purchase Return (Return outword)	Purchase Account
Sales Account
Goods Sent on Consignment	Sales Account
Sales	Sales Account
Sales Return (Return inward)	Sales Account
Closing Stock	Stock in Hand
Opening Stock	Stock in Hand
Creditors (Purchase goods in credit)	Sundry Creditors
Debtors (Sale goods in credit)	Sundry Debtors
Difference in Trial Balance (Dr or Cr)	Suspense Account