Excel User Group
Microsoft Excel blogs, forums, files. Read, ask questions, provide answers.
All Tags » SUM (RSS)

Browse Forum Posts by Tags

Showing related tags and posts for the Functions and Formulas forum. See all tags in the site
  • How can I simplify this if and statement

    The problem I run into with this formula is that I have to recreate it whenever I insert another row. I would like to simplify it so that it will be easier to update... or (even better) for Excel to automatically adjust the formula when I insert a new row. Please advise... =SUM(IF(K7="HP: Full Time...
    Posted to Functions and Formulas (Forum) by japi on Mon, Feb 25 2013
  • Need to make a formula

    HI, To all Skilled Guys, Skill is a beauty and it has always a flavour to amaze others. Can I please have a soilution of a formula from any skilled one out here! Thanks for your help. My query is: If Cell A1 contains "S" and cell B1 is greater than Cell G1 then Cell J1 (B1-G1) should be positive...
    Posted to Functions and Formulas (Forum) by smahk on Fri, Apr 13 2012
  • Help

    Hi. I need help with a type of counting problem. I have a huge excel data file with over 50,000 data entry points. It is forex data. I have a list of several banks. And their trade dates, and a bunch of other information columns that are cost, volume, what currency traded in, and more complicated diagnostic...
    Posted to Functions and Formulas (Forum) by eeanil on Mon, Apr 18 2011
  • Matching criteria in 2 columns to look at a 3rd column of numbers to create a sum

    Here is a typical row in the spreadsheet which is nearly 4000 rows of data: Description WBS WBD Material Qty Mea Size | Ball Valve, V600, 02 | C12DO | F1804B | CARBON STEEL, PIPING | 12 | EA | 1" | Im trying to use the "Description" & "WBS" columns for the criteria to match...
    Posted to Functions and Formulas (Forum) by jimbo5129 on Mon, Aug 9 2010
  • Dealing With Negatives

    I have a sheet containg two columns, frmatted as currency and to show negative numbers ehere approriate. e.g -£25.00 One colum shows a positive number of £3.00 (Cell A1) whilst the other shows -£1.00. (Cell D2) When I do the =SUM formula as =SUM(A1-D2) I get the result of £4.00...
    Posted to Functions and Formulas (Forum) by ian green on Sat, Aug 7 2010
  • Sum last 10 values

    Hi all With the data below :- how can I sum the last 10 cells in the row from 2-11 (row 1=32) and (row 2=25) Data is added to columns 12 to ? at a later time. Derek 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 1 1 5 0 1 4 1 7 2 4 7 3 5 2 2 2 2 3 2 3 2 2
    Posted to Functions and Formulas (Forum) by Derek McGill on Mon, Dec 21 2009
  • Re: Summing across multiple worksheets

    Max-Phillippe You reference across sheets like so =SUM(Sheet1:Sheet10!A1:A2)
    Posted to Functions and Formulas (Forum) by Nick Hodge on Mon, Jun 22 2009
Page 1 of 1 (7 items)
Copyright Excel User Group and the relevant contributors, 2010. All Trade Marks acknowledged. This site is a peer-to-peer site and NOT affiliated in any way to Microsoft Corp. All rights reserved.