-
https://clinton.presidentiallibraries.us/files/original/d0bb0de1bb00ee10125ba76320c38054.pdf
92c4c19be9a92be8ca32f5513b8a3c1d
PDF Text
Text
-~ f\:bout calculating a value based on a condit~on
Page 1 of4
About calculating a value based on a condition
This topic provides reference information about:
QVJ;[V!eW
The SUMIF and COUNTIF worksheet functions
The IF
WOrKsJ:Le~t
functioJ}
IheCoodJtIoD",LSu I1L\tViz",n:!
Overview
A formula in Microsoft Excel performs calculations on values in your worksheet. Typically, formulas perform
calculations on all the values in a given range. However, what if you want Excel to change your formula if a certain
condition is true, or what if you want to include only the values that meet certain conditions in the calculation? For
example, you might want to track the orders placed by your salespeople and then summarize the sales for each
salesperson without reorganizing your data. Or you might want to determine the bonus amount awarded for each'
sale, based on the total invoice amount. When you want formulas to perform conditional tests, you can use
conditional formulas in Excel.
'.
.
.
A list o.f sales 'by salesperso.n: Use co.nditio.nal fo.rmulas to. calculate, bo.nus percentages and to. summarize, per salesperso.n, the
number o.f o.rders placed and the to.tal amo.unt invo.iced during a given perio.d.
Excel includes three worksheet functions that calculate results based upon conditions. To countthe number of
occurrences that a specific value appears in a range of cells, use the COUNTIF worksheet function. To calculate a
total amount based on a single condition, use the SUMIF worksheet function. To return one of two values - such'
as the bonus percent amount - use the IF worksheet function.
.
If you are not familiar with wc;>rksheet functions, the Conditional Sum Wizard that can assist you with creating
formulas that calculate sums based on conditions.
More information
How formulas calculate values
Learn about
uSi~g
functions to
cal~ulate
values
Return to.
toP
The SUMIF and COUNTIF worksheet functions
Suppose that you want to create a summary of that shows, for each salesperson, the total number of orders
placed and the total amount invoiced for a given period. To count the number of orders placed, use the COUNTIF
worksheet function. To calculate the total amount invoiced, use the SUMIF worksheet function.
COUNTIF
The COUNTIF worksheet function counts the number of orders placed for each salesperson.
mk:@MSITStore:C:\Program%20Files\Microsoft%200ffice\Office\l .. .IxlconCondFormulas.ht
8/4/00
�AiJout calculating a value based on a condition'
Page 2 of4
COUNTIF has two arguments: the range to be checked and the value to check for within the range (the criteria).
=COUNTIF(ra nge,criteria)
For Buchanan, the function (in cell B32) looks like this:
=CQUNTIF(A2:A26,A32)
The function counts the number of times the name in ,cell A32 (the criteria argument) appears in the Salesperson
list (A2:A26, the range argument).
SUMIF
The SUMIF worksheet function calculates the total amount invoiced for each salesperson.
The SUMIF worksheet function checks for a value within a range and then sums all the corresponding values in
another range. SUMIF has three arguments: the range to be checked, the value to check for within the range (the
criteria), and the range containing the values to be summed.
=SU MIF{ range,criteria,sumJange)
For Buchanan, the function (in cell C32) looks like this:
=SUMIF (A2 :A26, A32, B2: B26)
The formula checks for the text in,cell A32 (the criteria argument) in the Salesperson list (A2:A26, the range
argument) and then sums the corresponding amounts from the Total Invoice column (B2:B26 the sum_range
argument).
More information
Learn about using functions to cal(;l,llate vallJ§
l.e,qLfLaJtQ1!UbS!,C.Q!.tl"JTIF wQEKs.heJ;L[1,l ncllo n
,Learn aboutJ;he SUMIF worksheeJ function
Return to top'
The IF worksheet function
Suppose that your company determines sales bonuses on a sliding scale, awarding either 10 percent or 15
percent, based on the invoice amount. To determine which one of two values to use, based on a condition that is
either true,or false, use the IF worksheet function.
mk:@MSITStore:C:\Program%20Files\M;icrosoft%200ffice\Office\1 .. .IxlconCondFormulas.ht
8/4/00
�.. About calculating a value based on a condition
Page 3 of 4
The IF worksheet function returns a bonus of either 10% or 15%, based'on the invoice amount.
The IF worksheet function checks a condition that must be either true or false: If the condition is true, the function
returns one value; if the condition is false, the function returns another value. The function has three arguments:
the condition you want to check, the value to return if the condition is true, and the value to return if the condition
is false.
=IF(logicaLtest,value_iCtrue,value_iCfalse) .
For Suyama's $8,000 invoice, the function (in cell C4) looks like this:
=IF(B4<10000;10%,15%)
If the invoice amount is less than $10,000 (the logicaLtest argument), the bonus is 10 percent (the
value_iCtrue argument). If the invoice amount is $10,000 or greater, the bonus is 15 percent (the value
_iCfalse argument).
More information
Learn about usingJunctions tocalculate values
Learn about the IF worksheetfunction
Return to
mQ
The Conditional Sum Wizard
Suppose you have multiple conditions you want to check. The Conditiona! Sum Wizard can create the conditional
formulas for you.
The Conditional Sum Wizard quickly builds formulas that contain multiple conditions. You can use the mouse to define the
conditions and then the wizard adds the formulas to your worksheet.
In the wizard, you specify the location of the list, the condition to check, and the location for the result. In the
preceding example, you are summing the invoice amounts for Buchanan's sales that were greater than $10,000.
rnk:@MSITStore:C:\Prograrn%20Files\Microsoft%200ffice\Office\l ...lxlconCondForrnulas.ht
8/4/00
�·
"
About calculating a value based on a condition
Page 40f4
The wizard then creates an array formula that calculates the result for you. If you need to change the condition,
you can use the wizard again and replace the results in the location you originally specified.
.
The Conditional Sum Wizard is an a~ct~jnprogrC'imsuppHedwjth·E)(q:~[.
More information
SJ,JJ:nmaribe-yj"ll\'Le.S_thiiLI1J.e.et.cQnd[tiQn~y.....Ysing.Jb.e.,-C.ondltiQJ1aLS_LJDJ..WJ;;an1
Learn about arra¥ formulas
Return to rot:).
Additional resources
"
mk:@MSITStore:C:\Program%20Files\Microsoft%200ffice\Office\1 ...1xlconCondFQrmulas.ht
8/4/00
�\
·1
�",'
.'
Value of gold bars shipped out of the Foreign Exchange Depository suspected of
containing victim gold: $ 89,166,978.11
Percentage of gold bars from FED suspected of containing victim gold: 65.7%
Value of gold ~oin recovered from German Embassy, Lisbon and sent to FRBNY:
$41,120.24
(5,000 Swiss Sovereigns weighing 1174.864 Troy Ounces fine gold)
Value of gold coin recovered from German Embassy, Madrid and sent to FRBNY:
$1,403.75
(322 coins weighing 40.107 Troy Ounces fine gold)
•
.
. "~j:'';'i'~'"
�~.
--,' .J
Gold Bars That Came Under US Control Which Can Be Suspected of Containing Victim Gold
Unlike most of the assets tracked in this study, for which estimates are drawn from the incoming
inventories of the Foreign Exchange Depository, the figures .for gold bars suspected of containing
victim gold are drawn from the records of shipments out ofthe FED. These shipments, which
include the preliminary distribution ofthe Tripartite Commission for the Restitution of Monetary
Gold in November 1947 and the transfer of the remaining gold at the FED to the TGC account at
the Bank of England in the summer of 1948, provide detailed bar lists that permit categorization of
the gold. These shipments and gold that was restituted directly to Hungary account for over 88% of
the gold bars held by US forces at the FED. The data for the identified bars can be analyzed in at
least three contexts: 1) against all tpe gold bars held at the FED; 2) against the total of gold bars
shipped in the Preliminary Distribution, to the Bank' of England and to Hungary for direct
restitution; and 3) against the total of gold bars 'shipped in Preliminary Distr1bution and in the Bank
of England.. When viewed against all the gold bars held at the FED, 54.79% can be suspected of
containing victim gold (2,547,627.964 1 4,649,238.704 Troy.ounces fine gold). When viewed
against the total bars shipped in the Preliminary Distribution, to the Bank of England and to
Hungary for direct restitution, 62.18% can be suspected of containing victim gold (2,547,627.9641
4,097,102.17 Troy ounces fine goid). When viewed against the tot~l bars shipped in the
Preliminary Distribution and to the Bank of England, 80.15 % can be suspected of containing victim
gold (2,547,627.964/3,178,423.72 Troy ounces fine gold). Supportingdata for these figures can
be found in tables prepared for the Gold Team Report: Appendix B, Tally of monetary gold held at
the FED and Appendix C-l, Tally of monetary gold shipped out of the FED.
�����������������������������������������������������������������������������������
Dublin Core
The Dublin Core metadata element set is common to all Omeka records, including items, files, and collections. For more information see, http://dublincore.org/documents/dces/.
Title
A name given to the resource
Presidential Advisory Commission on Holocaust Assets
Description
An account of the resource
<p>The Presidential Advisory Commission on Holocaust Assets in the United States, formed in 1998, was charged with investigating what happened to the assets of victims of the Holocaust that ended up in the possession of the United States Federal government. The final report of the Commission, <a href="http://govinfo.library.unt.edu/pcha/PlunderRestitution.html/html/Home_Contents.html"> “Plunder and Restitution: Findings and Recommendations of the Presidential Advisory Commission on Holocaust Assets in the United States and Staff Report"</a> was submitted to President Clinton in December 2000.</p>
<p>Chairman - Edgar Bronfman<br /> Executive Director - Kenneth Klothen</p>
<p>The collection consists of 19 series. The first fifteen series of the collection are composed mostly of photocopied federal records. These records were reproduced at the National Archives and Records Administration by commission members for their research. The records relate to Holocaust assets created between the mid 1930’s and early 1950’s by a variety of U. S. Government agencies and foreign sources.</p>
<p>Subseries:<br /><a href="http://clinton.presidentiallibraries.us/items/browse?advanced%5B0%5D%5Belement_id%5D=39&advanced%5B0%5D%5Btype%5D=is+exactly&advanced%5B0%5D%5Bterms%5D=Art+and+Cultural+Property+">Art and Cultural Property</a><br /><a href="http://clinton.presidentiallibraries.us/items/browse?advanced%5B0%5D%5Belement_id%5D=39&advanced%5B0%5D%5Btype%5D=is+exactly&advanced%5B0%5D%5Bterms%5D=Gold+">Gold</a><br /><a href="http://clinton.presidentiallibraries.us/items/browse?advanced%5B0%5D%5Belement_id%5D=39&advanced%5B0%5D%5Btype%5D=is+exactly&advanced%5B0%5D%5Bterms%5D=Gold+Team+Review+Form+Binders+">Gold Team Review Form Binders</a><br /><a href="http://clinton.presidentiallibraries.us/items/browse?advanced%5B0%5D%5Belement_id%5D=39&advanced%5B0%5D%5Btype%5D=is+exactly&advanced%5B0%5D%5Bterms%5D=Art+and+Cultural+Property+and+%E2%80%9COthers%E2%80%9D+Review+Form+Binders">Art and Cultural Property and “Others” Review Form Binders</a><br /><a href="http://clinton.presidentiallibraries.us/items/browse?advanced%5B0%5D%5Belement_id%5D=39&advanced%5B0%5D%5Btype%5D=is+exactly&advanced%5B0%5D%5Bterms%5D=Non-Gold+Financial+Assets+Review+Form+Binders">Non-Gold Financial Assets Review Form Binders</a><br /><a href="http://clinton.presidentiallibraries.us/items/browse?advanced%5B0%5D%5Belement_id%5D=39&advanced%5B0%5D%5Btype%5D=is+exactly&advanced%5B0%5D%5Bterms%5D=History+Associates+Binder+">History Associates Binder</a><br /><a href="http://clinton.presidentiallibraries.us/items/browse?advanced%5B0%5D%5Belement_id%5D=39&advanced%5B0%5D%5Btype%5D=is+exactly&advanced%5B0%5D%5Bterms%5D=Non-Gold+Financial+Assets+Review+Form+Binders+%282%29">Non-Gold Financial Assets Review Form Binders (2)</a><br /><a href="http://clinton.presidentiallibraries.us/items/browse?advanced%5B0%5D%5Belement_id%5D=39&advanced%5B0%5D%5Btype%5D=is+exactly&advanced%5B0%5D%5Bterms%5D=Financial+Assets+Documents">Financial Assets Documents</a><br /><a href="http://clinton.presidentiallibraries.us/items/browse?advanced%5B0%5D%5Belement_id%5D=39&advanced%5B0%5D%5Btype%5D=is+exactly&advanced%5B0%5D%5Bterms%5D=RG+84%2C+Foreign+Service+Posts+of+the+State+Department%E2%80%94Turkey">RG 84, Foreign Service Posts of the State Department—Turkey</a><br /><a href="http://clinton.presidentiallibraries.us/items/browse?advanced%5B0%5D%5Belement_id%5D=39&advanced%5B0%5D%5Btype%5D=is+exactly&advanced%5B0%5D%5Bterms%5D=Financial+Assets+Documents">Financial Assets Documents</a><br /><a href="http://clinton.presidentiallibraries.us/items/browse?search=&advanced%5B0%5D%5Belement_id%5D=39&advanced%5B0%5D%5Btype%5D=is+exactly&advanced%5B0%5D%5Bterms%5D=%5BJewish+Restitution+Successor+Organization+%28JRSO%29%2C+Oral+Histories%5D&range=&collection=20&type=&user=&tags=&public=&featured=&exhibit=&submit_search=Search+for+items">[Jewish Restitution Successor Organization (JRSO), Oral Histories]</a><br /><a href="http://clinton.presidentiallibraries.us/items/browse?advanced%5B0%5D%5Belement_id%5D=39&advanced%5B0%5D%5Btype%5D=is+exactly&advanced%5B0%5D%5Bterms%5D=PCHA+Secondary+Sources">PCHA Secondary Sources</a><br /><a href="http://clinton.presidentiallibraries.us/items/browse?advanced%5B0%5D%5Belement_id%5D=39&advanced%5B0%5D%5Btype%5D=is+exactly&advanced%5B0%5D%5Bterms%5D=Researcher+Notes">Researcher Notes</a><br /><a href="http://clinton.presidentiallibraries.us/items/browse?advanced%5B0%5D%5Belement_id%5D=39&advanced%5B0%5D%5Btype%5D=is+exactly&advanced%5B0%5D%5Bterms%5D=Unnumbered+Documents+from+Archives+II+and+Various+Notes">Unnumbered Documents from Archives II and Various Notes</a><br /><a href="http://clinton.presidentiallibraries.us/items/browse?advanced%5B0%5D%5Belement_id%5D=39&advanced%5B0%5D%5Btype%5D=is+exactly&advanced%5B0%5D%5Bterms%5D=RG+260%2C+Finance+Inventory+Forms">RG 260, Finance Inventory Forms</a><br /><a href="http://clinton.presidentiallibraries.us/items/browse?advanced%5B0%5D%5Belement_id%5D=39&advanced%5B0%5D%5Btype%5D=is+exactly&advanced%5B0%5D%5Bterms%5D=Reparations">Reparations</a><br /><a href="http://clinton.presidentiallibraries.us/items/browse?advanced%5B0%5D%5Belement_id%5D=39&advanced%5B0%5D%5Btype%5D=is+exactly&advanced%5B0%5D%5Bterms%5D=Chase+National+Bank">Chase National Bank</a><br /><a href="http://clinton.presidentiallibraries.us/items/browse?advanced%5B0%5D%5Belement_id%5D=39&advanced%5B0%5D%5Btype%5D=is+exactly&advanced%5B0%5D%5Bterms%5D=Administrative+Files">Administrative Files</a><br /><a href="http://clinton.presidentiallibraries.us/items/browse?advanced%5B0%5D%5Belement_id%5D=39&advanced%5B0%5D%5Btype%5D=is+exactly&advanced%5B0%5D%5Bterms%5D=Art+%26+Cultural+Property+Theft">Art & Cultural Property Theft</a></p>
<p>Topics covered by these records include the recovery of confiscated art and cultural property; the reparation of gold and other financial assets; and the investigation of events surrounding capture of the Hungarian Gold Train at the close of World War II. These files contain memoranda, correspondence, inventories, reports, and secondary source material related to the final disposition of art and cultural property, gold, and other financial assets confiscated during the Holocaust.</p>
<p>For more information concerning this collection consult the<a href="http://clinton.presidentiallibraries.us/items/show/35992"> finding aid</a>.</p>
Provenance
A statement of any changes in ownership and custody of the resource since its creation that are significant for its authenticity, integrity, and interpretation. The statement may include a description of any changes successive custodians made to the resource.
Clinton Presidential Records: White House Staff and Office Files
Publisher
An entity responsible for making the resource available
Clinton Presidential Library & Museum
Is Part Of
A related resource in which the described resource is physically or logically included.
<a href="http://clinton.presidentiallibraries.us/items/show/35992" target="_blank">Collection Finding Aid</a>
<a href="https://catalog.archives.gov/id/1040718" target="_blank">National Archives Catalog Description</a>
Extent
The size or duration of the resource.
2954 folders
Text
A resource consisting primarily of words for reading. Examples include books, letters, dissertations, poems, newspapers, articles, archives of mailing lists. Note that facsimiles or images of texts are still of the genre Text.
Original Format
The type of object, such as painting, sculpture, paper, photo, and additional data
Paper
Dublin Core
The Dublin Core metadata element set is common to all Omeka records, including items, files, and collections. For more information see, http://dublincore.org/documents/dces/.
Title
A name given to the resource
Skwirot, Robert - Numbers [1]
Creator
An entity primarily responsible for making the resource
Presidential Advisory Commission on Holocaust Assets in the United States
Art & Cultural Property Theft
Is Part Of
A related resource in which the described resource is physically or logically included.
Box 211
<a href="http://clintonlibrary.gov/assets/Documents/Finding-Aids/Systematic/Holocaust-Assets.pdf" target="_blank">Collection Finding Aid</a>
<a href="http://catalog.archives.gov/description/6997222" target="_blank">National Archives Catalog Description</a>
Provenance
A statement of any changes in ownership and custody of the resource since its creation that are significant for its authenticity, integrity, and interpretation. The statement may include a description of any changes successive custodians made to the resource.
Clinton Presidential Records: White House Staff and Office Files
Format
The file format, physical medium, or dimensions of the resource
Adobe Acrobat Document
Publisher
An entity responsible for making the resource available
Clinton Presidential Library & Museum
Medium
The material or physical carrier of the resource.
Reproduction-Reference
Date Created
Date of creation of the resource.
6/24/2013
Source
A related resource from which the described resource is derived
6997222-skwirot-robert-numbers-1
6997222