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:
=SUMIF($C$3:$C$13,C16,$D$3:$D$13)
=SUMIF($C$3:$C$13,C17,$D$3:$D$13)
=SUMIF($C$3:$C$13,C18,$D$3:$D$13)
respectively.

There is another …IF formula: COUNTIF

Entry filed under: Formula, Gampang. Tags: .

Generating Normal Distribution Data Dayname (English Version)

Leave a Reply

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

WordPress.com Logo

You are commenting using your WordPress.com 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 )

Google+ photo

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

Connecting to %s

Trackback this post  |  Subscribe to the comments via RSS Feed


We Moved!

Kami telah pindah ke www.excelquotient.com

Tweet XQ

Kapsul XQ Terkini

Archives

Annex


Langganan
RSS Kapsul XQ
RSS Komentar XQ

# Blog Walkers
web tracker

Ranks
My Popularity (by popuri.us)

Lisensi
Creative Commons License

%d bloggers like this: