Solved

# could someone tell me the what the following excel formula is doing?

Posted on 2011-10-11
Medium Priority
138 Views
Hello Experts,

Could someone please tell me the meaning of following formula?

0
Question by:KoolAsIce
• 2

LVL 11

Expert Comment

ID: 36952577
You want to know what SUMIF function do? Look here
0

LVL 33

Accepted Solution

jppinto earned 2000 total points
ID: 36952581
=SUMIF(range_to_check_for_criteria, criteria, range_to_sum)

So your formula is checking on entire column G for the value on cell K3 and on the rows that it finds it, is summing the corresponding values on column R.

jppinto
0

LVL 33

Expert Comment

ID: 36952593
Here's my article about SUMIF() function:

http://excel-user.blogspot.com/2011/02/sumif-and-sumifs-functions.html

jppinto
0

Author Comment

ID: 36952703
Thanks jppinto! That really helped me!
0

## Featured Post

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
This article describes a serious pitfall that can happen when deleting shapes using VBA.
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabilâ€¦
This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.
###### Suggested Courses
Course of the Month17 days, 6 hours left to enroll