sum in columns

  1. S

    SUM a dynamic range

    I'm new at this excel stuff. My eyes are laying on my keyboard for having watched umteen "How To Videos" yet I still can't figure this out. ...just shoot me! I'm a DBA so my thought processes, well, is a bit different... How do you SUM a dynamic range??? This is simple, right?? Heres my...
  2. D

    Sum column with vary length issue

    I am currently using the following code to sum a column of transaction amounts (dollars and cents) where the column varies in length and I am having an issue.<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> <o:p> </o:p> <o:p> </o:p> <o:p> </o:p> Dim...
  3. F

    Grand total in pivot table different from the sum of the rows...

    I created several pivot tables with calculated fields and it appears that , for those calculated fields, the Grand total value of these columns are different (sometimes lower sometimes higher) from the sum of each individual rows value.... :confused: Does someone had the same an issue and an...
  4. E

    trying to sum values if values corresponding are the same

    hiya, i have a small project and i can''t figure it out on myself. What i need to do is to create a formula which will find the same values in column A and will sum the corresponding to them values from columns B:E. I have tried SUMIF but if seems not to work in more than 1 columns. this is a...

Some videos you may like

This Week's Hot Topics

Top