How do you sum a condition in excel?



How do you sum a condition in excel?..

Answer / Bajrang Kumar

To sum a condition in Excel, use the SUMIF function. The syntax is SUMIF(range, criteria, [sum_range]). 'Range' is the range of cells to apply the criteria, 'criteria' is the value or condition you want to meet, and 'sum_range' is the range of cells to sum if the condition is met.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More MS Excel Microsoft Interview Questions

How do you use the choose function in excel?

1 Answers  


How do I count the same number in excel?

1 Answers  


How do I split a number into two cells in excel?

1 Answers  


Can you concatenate a range in excel?

1 Answers  


My stop recording toolbar has disappeared. How do I get it back?

1 Answers  


I created a worksheet in excel 95. In excel 97, excel ignores my page breaks?

1 Answers  


What is the order of sequence of operating mathematical operation in excel?

1 Answers  


What is the find function in excel?

1 Answers  


How do you insert a tab on excel?

1 Answers  


When should I use microsoft access vs excel?

1 Answers  


How do I maximize my workspace in excel?

1 Answers  


How do I create a pop up in excel?

1 Answers  


Categories