Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / General Excel Questions / May 2008

Tip: Looking for answers? Try searching our database.

SUMIF funkcion example

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
vava - 21 May 2008 12:00 GMT
I have to use SUM IF Funkcion, and I am not sure how. What to put in Range,
Criteria and Sum_range?
Mike H - 21 May 2008 12:15 GMT
Excel help is quite good for this function

Range = The range to evaluate
Criteria  = What to evaluate that range for
Sum Range = The range to sum if the criteria evaluates as true

So for numbers in a range try
=SUMIF(A1:A6,"="&22,B1:B6)
or text try
=SUMIF(A1:A6,"=a",B1:B6)

Mike

> I have to use SUM IF Funkcion, and I am not sure how. What to put in Range,
> Criteria and Sum_range?
Sherry Cekala - 21 May 2008 18:37 GMT
Range = the values you want to compare TO
Criteria  = What you're looking for in that range
Sum Range = The range to sum if for the rows that meet the criteria

To clarify a bit, assume that you have the following data:

Cells A1:A10 - lists vendors from which you've purchased equipment (AT&T,
IBM, and Sun)
Cells B1:B10 - lists the cost of the items purchased.

Assume that there are a couple of entries for each vendor, and you want
totals for all three.

the formula to sum the AT&T values would be
=sumif($A$1:$A$10,"AT&T",$B$1:$B$10)

For the other 2 vendors, you'd simply replace "AT&T" with "IBM" or "Sun".  
The quotes around the names are necessary because these items are text values
(in this example).  You could also use a cell reference if the value exists
in a cell elsewhere.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.