Help with sumif calculation ytd in Excel 2010

Asked By Joseph H Higuchi 70 points N/A Posted on - 10/31/2013

How to use sumif calculation in excel when I am looking inside extensive ranges of data? Does it add the sum range correctly?

• Status: Open
• Question Views: 1073
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: Feature tips

Answered By Aron Hank 0 points N/A #186131

Help with sumif calculation ytd in Excel 2010

SUMIF function in Excel 2010 is used to get sum of values in a range that meets your criteria.

The formula for SUMIF function is as follows

= SUMIF (Range, Criteria, Sum Range)

where Range is the group of cells on which the function is applied.

Criteria is the condition that determines whether the cell is to be summed or not.

Sum Range is the data range to be summed if first range meets the specified criteria. If this range is omitted, the first range is summed instead.

 

The Sum Range in the formula is optional. That is, if a Sum Range is not provided then the sum occurs on the former two inputs, i.e Range and Criteria.

 

Following is an example. Where the formulas are applied and answer to the formula is provided inthe next cell.

 

About Aron Hank

Questions
0

Answers
100

Best Answers
21

• Vote Up 0 Vote Down

• Posted on - 11/11/2013
• Question Category: Feature tips