Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 10-08-2011, 07:49 AM
manich1 manich1 is offline "Sumif"Confusion! Windows Vista "Sumif"Confusion! Office 2010 32bit
Novice
"Sumif"Confusion!
 
Join Date: Mar 2011
Posts: 8
manich1 is on a distinguished road
Default "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
Reply With Quote
 



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
"Sumif"Confusion! "Table of content" based on "Normal Style" behavior!!!! Jamal NUMAN Word 4 07-08-2011 04:12 AM
"Sumif"Confusion! How to choose a "List" for certain "Heading" from "Modify" tool? Jamal NUMAN Word 2 07-03-2011 03:11 AM
"Sumif"Confusion! 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

Other Forums: Access Forums

All times are GMT -7. The time now is 07:41 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft