sum formula

This post was also added to EXCELGURU.CA (https://www.excelguru.ca/forums/showthread.php?8863-Ongoing-Total-Formula&p=36456#post36456) I am looking for help regarding an ongoing total formula I have a workbook with multiple sheets, and additional sheets being added daily. Cell B126 will...

Hello, I'm working on a Excel document that automatically inserts formulas. In the attachment you can find an explanation (click here). I just started using VBA-codes and I can't find any solution for my problem.:confused: I already found some VBA-codes that automatically insert the SUM...

Hi Experts, I want to Sum the alphabet's assigned values till 2 digits, where each alphabets are assigned with value which can be changed as and when needed. Below example might give more clarity on my question. Sorry for my poor language. I'm having the word "ABCDE" in cell "A2" and I want...

<tbody> I'm looking to sum totals in a drop down list as follows:In column C (lines 7 - 38) I have a drop down list that assigns categories to that particular line. In column F (lines 7 - 38) there are totals that apply to that particular line item that are numbers. These totals change with each...

Hi all I am back to be schooled on macros. I need help building a macro to use the sum formula on certain values separated by a blank row The data looks like this. 9564.46 2315.15 84842.15 154.32 4844.185 751.15 1548.48 154.84 154.84 I don't know if there is an easy way to paste formulas in...

Hi, everyone ! I have a column with a formula that returns a number or a FALSE. 1 FALSE 2 FALSE 3 0 4 FALSE 5 FALSE 6 FALSE 7 1 8 FALSE 9 FALSE 10 FALSE 11 2 12 FALSE 13 6 14 FALSE 15 FALSE Now, the pattern of numbers and FALSE's is irregular...

I pull this pending revenue report everyday and the column L contains the amount due for each customer. I want my macro to add the total of those amounts in the next blank cell below after the column ends. Suppose the data ranges from L2:L13 then L14 should have the formula =SUM(L2:L13), if...

Hi Experts, Sorry this one has me stumped and I’m sure it’s simple, I would like to sum a column which has been created via VBA selecting different sections so the column “letter” it’s in and the length or number of rows will vary. Due to this I’m using the variables from the VBA code within...

Hi, this is what I want excell to do =SUMIF(additional,additional>0,Principal) count amount in "principal" row if aproprieate cell in "additional" row is greater than null but my "additional>0" is not apprehensible for excell could you help me?

Hello everyone, Add up every 7 lines, then the next 7 -- Excel or Access version: Excel 2010 Computer operating system: Windows XP Sample data: "Excel WorkbookABCDEFGH1MCDayDateRevenueDayMC-CYSP-SummerCYSP7 Days of Revenue2MC-CYSP-SummerDay 18/15/2011$30Day...