SUMIF Formula

May 17, 2006 at 10:38 am Leave a comment

This is request formula from Miss Sri. How to use SUMIF formula?

SUMIF is a built-in formula in Excel. It means, that u don’t have to make it by yourself. U just use it and u have to know how to use it. Actually, you can read it in Ms Excel’s Help? And I think the Help is helpfull enough. But less application to the case.

SUMIF(range, criteria, sum_range)
Range is the range of cells you want evaluated.
Criteria is the criteria in the form of a number, expression, or text that defines which cells will be added. For example, criteria can be expressed as 32, “32”, “>32”, “apples”.
Sum_range are the actual cells to sum. The cells in sum_range are summed only if their corresponding cells in range match the criteria. If sum_range is omitted, the cells in range are summed.

OK. I will use the data from the previous posting, AVERAGEIF Formula. The goal is to find the sum of each subject.

U just put these formulas in cell of D16, D17, and D18:

There is another …IF formula: COUNTIF


Entry filed under: Formula, Gampang.

Generating Normal Distribution Data Dayname (English Version)

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s

Trackback this post  |  Subscribe to the comments via RSS Feed

We Moved!

Kami telah pindah ke

Tweet XQ

Kapsul XQ Terkini



RSS Kapsul XQ
RSS Komentar XQ

# Blog Walkers
web tracker

My Popularity (by

Creative Commons License

%d bloggers like this: