#1
|
|||
|
|||
"Sumif"Confusion!
Hi all,
I am teaching my self Excel from books and the internet. In one self test there is the following task... use a function to total figures in the purchase price column IF the weight is greater than 1 The result is then to be displayed in a cell on a seperate sheet. On the sales sheet there is a column of figures entitled "purchase price" and a column of figures entitled "weight of items" I know i need to use a sumif function but what data goes where in the sumif dialogue box? Any help greatly appreciated Mark |
#2
|
||||
|
||||
Hi Mark,
Like this: =SUMIF(WeightRange,">1",PriceRange) Have a look at this tutorial for more information. |
#3
|
|||
|
|||
Hi Colin
Thanks for the reply. So you can add all the formula directly into the top "Range" box in the "sumif" dialogue box,no need to use "criteria" and "sum Range". or directly to fomulae bar much appreciated |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How to edit the "Format" and the "show level" of an EXISTING table of content? | Jamal NUMAN | Word | 2 | 08-14-2011 10:46 AM |
"Table of content" based on "Normal Style" behavior!!!! | Jamal NUMAN | Word | 4 | 07-08-2011 04:12 AM |
How to choose a "List" for certain "Heading" from "Modify" tool? | Jamal NUMAN | Word | 2 | 07-03-2011 03:11 AM |
Why the "table of contents" doesn't take the same format of the "headings"? | Jamal NUMAN | Word | 5 | 06-15-2011 10:14 AM |
"Microsoft Excel Application" missing in the "Component Services" on win08 | sword.fish | Excel | 0 | 02-26-2010 02:09 PM |