What is the purpose of sumifs in excel?



What is the purpose of sumifs in excel?..

Answer / Sanjay Kanaujia

"Purpose":"SUMIFS combines multiple criteria to sum values from a range based on the conditions you specify. It lets you perform complex calculations by comparing data in different cells and ranges." "Syntax":"=SUMIFS(sum_range, criteria_range1, criteria1, [criteria_range2, criteria2], ...)"

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More MS Excel Microsoft Interview Questions

How do you write a subtraction formula in excel?

1 Answers  


Where is average function in excel?

1 Answers  


How do you create a trend in excel?

1 Answers  


How do I use pivot tables in excel?

1 Answers  


How do you delete specific text in excel?

1 Answers  


How do I make rows and columns in excel?

1 Answers  


What is the maximum number of rows in excel 2007?

1 Answers  


Why use a database over excel?

1 Answers  


What is meant by conditional formatting?

1 Answers  


How do I split a number into another cell in excel?

1 Answers  


What is the or function in excel?

1 Answers  


How do you analyze data in excel?

1 Answers  


Categories