sum in columns

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...

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...

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...

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...