sum function

Hi everyone, I´m faily new to VBA, and I´m having some issues trying to enter a function to sum the values of a row within a range of columns. My document has a column for totals, and some other columns populated with data from another sheet. I want the totals column to sum the values in the...

Hi All, I am trying to run the below code. All variables are getting value except 'rsum" Dim k As Integer, rsum As Double Dim svalue As String Dim numcol As Long Dim strrng As Variant Dim endrng As Variant k = 7 Do While Sheets("BG").Cells(k, 11) <>...

Hello! I am trying to fetch data from a text file. After extracting the needed info on the file, I converted the quantity from a string to a number. I would like to add all of the quantities, so I used the SUM function in excel VBA. However, I am getting an incompatible data type error for...

Excel 2010 <colgroup><col style="width: 25pxpx"><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col></colgroup><thead> A B C D E F G H I J K L M N O P Q R </thead><tbody> 1 Project Budget 2 3 Project Name...

I have 11 cells that are part of my question, A1, C1, C2, C3, C4, C5, E1, E2, E3, E4 and E5. A user will have an option to input an arbitrary value such as 200 or 400 into cells A1, C1, C2, C3, C4 and C5. The user must always enter a value into cell A1, however, each cell C1 through C5 will be...

Hi all I'm using this formula: =SUM(VLOOKUP((B82&C82),wkone,4,0),VLOOKUP((B82&C82),wktwo,4,0),VLOOKUP((B82&C82),wkthree,4,0),VLOOKUP((B82&C82),wkfour,4,0),VLOOKUP((B82&C82),wkfive,4,0)) I get a #VALUE error where any value returned by one of the VLOOKUPs is text. I've done a little research...

hey i have this tiny little problem. i have no idea why this is happening and what i can do to make it alright. formula in j4 to j20 is =IF(P2="",J4,H1+I1)...( as i go down to j5.. P2 becomes P3 and j4 becomes j5 and so on) now in cell j21 i have a sum function (=SUM(J4:J20)) sum function does...

Hi,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> Please clarify <o:p></o:p> When i paste the data in the columns like Process/Emp. Id./Targest. The pasted target values should automatically update in the respective process against the respective...

Need help with a formula on excel that I can't seem to get. Basically I trying to create a formula where the monthly interest payment is automatically calculated based in what range the monthly billing falls into, as well as what type payment it is (E33). But I have several variables. Is this...

Hello Guys, It's my first post an my Excel knowledge is pretty basic, so please pardon my ignorance in advance. I am trying to accomplish the following formula. I have to caculate the percentage of a loan based on the following: D3 and H3 are Currency Labels D4 is deposit amount that the...