sum a row

Hello everyone, In Excel, I entered two numbers in a single cell by using the Alt+Enter command to add a line break. I want to calculate the sum of these numbers, but I don't want to use VBA. I know ChatGPT can write VBA code, but I am looking for a non-VBA solution. Could someone help me with...

Hi All. I want to SUM a 12 month range of numbers starting with the first month that has a number >0, and to start a new SUM range from the month following the previous SUM range. For instance in the calendar year 2023, if April is the first month with a number >0, that would be the starting...

Hi Gurus, Good day! I just want to consult if there's a VBA way to combine the data (get the sum) of specific accounts? For example I have long list of data but need to combine the total data for Math & Science. Note that there are negative numbers sometimes and Reference 01 is the main...

QT 1g 2g 3g 5g 8g 10G 15G total 0 15 0 0 0 0 0 0 0 0 3 0 0 0 0 0 0 3 0 19 0 2 0 0 0 0 0 75 0 0 0 0 0 0 0 75 I am basically trying to find the sum of the different sizes of plants. There is a XLookup where it feeds the numbers in from a list, but the total is where I am...

Hello, I am preparing a sheet of Stock Trading and I have entered the formulae for all the expenses related to stock purchases. Sometimes the amounts are in fraction. When I compare the values in each cell those match exactly with the statement provided by my stock dealer. However, When I take...

I have a simple =SUM(A1:G1) formula here but it's not working. It's like it's missing column data and giving incorrect totals. Each result (A:G) is populated by an IF formula. Any thoughts why Sum would not be working properly? Auto Calculation is on, which is the only thing i can think of...

I have a row of values B:W that I would like to highlight if they sum up to a value in column A. And copy that row CF to 600 rows below. A visual of how many days it took a product to sell through. <tbody> sales units 1/1/18 1/2/18 1/3/18 1/4/18 1/5/18 1/6/18 22 10 24 9 18 29 4 45 9 19...

Hi all, I am having a problem with a double counting sumif, because of and array. <style type="text/css"><!--td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}--></style> <colgroup><col style="width: 232px"><col width="100"><col width="100"></colgroup><tbody> #f4f4f4[/URL]...

Hi Everyone. I'm new to excel and VBA. So maybe the question is a bit dumb. I got my macro reading different Excel file and combine as a big datasheet. I am facing problem in combining data. At First, I got 2 column and the sheet is blank. <tbody> Name Total </tbody> After I ran the...