![]() |
|
|
|
#1
|
||||
|
||||
|
Hi Mark,
Like this: =SUMIF(WeightRange,">1",PriceRange) Have a look at this tutorial for more information. |
|
#2
|
|||
|
|||
|
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 |