tell me how to use "sumif and" formula
Ram Avtar Singh (Nagari Sultanpur U.P.Delhi) 26 November 2010
To use the SUM and IF worksheet functions together to sum multiple criteria, refer to the following examples.
A1: Dept B1: Employees C1: Criteria A2: A B2: 2 C2: A A3: B B3: 4 C3: B A4: C B4: 3 A5: A B5: 3 A6: B B6: 3 A7: C B7: 2 A8: A B8: 4 A9: C B9: 3
Tanu (Accountant) 27 November 2010
i need to give two range i.e. name and units should be equal to differ criteria.
Ram Avtar Singh (Nagari Sultanpur U.P.Delhi) 27 November 2010
Please give example and get command in excel here.
Varun.T.K (CA Final, CS Executive) 27 November 2010
Pls help me-What command is used in excel 2003 to eliminate duplicate data.
Manoj Garg (Support on Tally Excel Password Recovery etc.) 27 November 2010
Babita Jain (Personal Assistant) 10 May 2021
Excel is the most powerful tool to manage and analyze various types of Data. This Microsoft Excel tutorial for beginners covers in-depth lessons for Excel learning and how to use various Excel formulas, tables and charts for managing small to large scale business process.
This free Excel videos for beginners course will help you learn Excel basics.