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

Posted on 2011-10-11
Last Modified: 2012-05-12
Hello Experts,

Could someone please tell me the meaning of following formula?

Thanks a lot in advance!  Excel formula
Question by:KoolAsIce
    LVL 11

    Expert Comment

    You want to know what SUMIF function do? Look here
    LVL 33

    Accepted Solution

    =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.

    LVL 33

    Expert Comment

    Here's my article about SUMIF() function:


    Author Comment

    Thanks jppinto! That really helped me!

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Better Security Awareness With Threat Intelligence

    See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

    Drop Down List with Unique/Distinct Values (enhancing the Combo-Box with a few steps and a little code) David miller (dlmille) Intro Have you ever created a data validation list from a database field or spreadsheet column (e.g., Zip Codes or Co…
    Improved? Move/Copy Add-in Replacement - How to avoid the annoying, “A formula or sheet you want to move or copy contains the name XXX, which already exists on the destination worksheet.” David Miller (dlmille)  It was one of those days… I wa…
    The viewer will learn how to simulate a series of coin tosses with the rand() function and learn how to make these “tosses” depend on a predetermined probability. Flipping Coins in Excel: Enter =RAND() into cell A2: Recalculate the random variable…
    The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …

    737 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    20 Experts available now in Live!

    Get 1:1 Help Now