## Excel SUM() Formula Not Working

I have a complex formula: two SUMIFS formula nested in a SUM formula. The concept is to sum amounts given a specific time period and specific account code.
This formula seems to work great. I get an amount of 4119.20 for one account, and -4119.20 for the other account. My other SUM formula, which is supposed to total the group, should be 0, but instead reads “9.09495E-13”.

I have six accounts in the group and one of them that is “0” appears to give this “9.09495e-13”. there are no transactions under this account at all.

Furthermore, I tried deleting the formula and just putting in “0”, but this also resulted in a sum of the group of “9.0495e-13”

I realize that this is vague, but I’m hoping someone else ran into a similar problem.

EDIT 18-07-18-2221:

## Excel 2016 Chart showing random dates in x axis

I’m simply trying to graph some time-scale data using a date column and 3 data columns, but Excel keeps screwing up the dates in the chart… (showing dates from year 1900-1903 instead of 2018)
Screenshot

All of my dates in the date column are between the 12th and 13th of November, 2018 (12/11/2018 and 13/11/2018) as in the screenshot, and the entire date column number format is set to Custom: dd/mm/yyyy HH:mm (why doesn’t Excel have this format as a predefined format??). I have also tried simply using the Date number format as well with no luck. The Excel chart doesn’t seem to think these are dates, since in the x-axis axis options, the bounds are numeric, not dates: Screenshot

The date column is actually calculated from the Unix timestamp column and converted to my timezone (+10.5hrs) using the formula: `(((A2/60)/60)/24)+DATE(1970,1,1)+TIME(10,30,0)`

Can someone tell me how to get the dates in the chart to actually use the dates in the date column? And let me know why there might be random dates everywhere in the first place?

## Difficulty appending to cell in Google Sheets (Excel) [migrated]

My goal is to automate making a calendar on Google Sheets. I used `=DATE(C1,A1,B1)` to make a date and then each following cell, I added 1 to the previous cell.

However, now I want to also automate making a time table with this spreadsheet. To append my list of times from below, I used ‘&’, but then the date 12/16/2018 became 43450.

``````3-4
4-5
5-6
6-7
7-8
8-9
9-10
``````

What am I overlooking? Any help is appreciated. I am new to Google Sheets, so sorry if this is a stupid question.

## Difficulty appending to cell in Google Sheets (Excel)

My goal is to automate making a calendar on Google Sheets. I used `=DATE(C1,A1,B1)` to make a date and then each following cell, I added 1 to the previous cell.

However, now I want to also automate making a time table with this spreadsheet. To append my list of times from below, I used ‘&’, but then the date 12/16/2018 became 43450.

``````3-4
4-5
5-6
6-7
7-8
8-9
9-10
``````

What am I overlooking? Any help is appreciated. I am new to Google Sheets, so sorry if this is a stupid question.

## Math or Logic Issue using Excel/Google Spreadsheet — Figuring Portion of a number based on two percentages

I have 70,000 troops and trying to use 16% power, but each troop has a different bonus to strength. I just can’t logically get there… I can get close by averaging % bonus, but it’s bothering me I can’t figure out the math/logic to get it 100% right

## Insertar datos desde EXCEL a una tabla en SQL SERVER

Tengo una hoja en Excel 2016 que contiene varias columnas con informaciÃ³n de mis clientes; la ruta del archivo es “D:Clientes.xlsx”.

Luego tengo una tabla “tb_clientes” en la Base de Datos “bd_comercial” (SQL Server 2008 R2) con los mismos nombres, orden, y cantidad de columnas que el archivo Excel.

Lo que quisiera saber es si, a travÃ©s de un query, puedo insertar los datos que aparecen en el archivo Excel a mi tabla en SQL Server de manera automÃ¡tica, todos los dÃ­as 1 de cada mes.

Por ahÃ­ me comentaron que se puede hacer a travÃ©s de un Job, espero me puedan ayudar. Gracias.

## Sharepoint properties update using Excel VBA

I am able to upload files to Sharepoint through VBA but I’m not able to update these properties to have their properties updated with ‘Document Status’ and ‘Confidentiality’ Fields.

Until these are updated, others are not able to see them.

## Linhas no export excel

Estou exportando uma listagem para excel, mas quando abro o excel ele vem sem as divisÃ³rias.

``````select(\$sql);

/*
* Criando e exportando planilhas do Excel
* /
*/
// Definimos o nome do arquivo que serÃ¡ exportado
\$arquivo = 'planilha.xls';
// Criamos uma tabela HTML com o formato da planilha
\$html = '';
\$html .= '';
\$html .= '';
\$html .= '';
\$html .= '';
\$html .= '';
\$html .= '';
\$html .= '';
\$html .= '';
\$html .= '';
\$html .= '';
\$html .= '';
\$html .= '';
\$html .= '';
\$html .= '';
\$html .= '';
\$html .= '';
\$html .= '';
}
\$html .= '';
header ("Expires: Mon, 26 Jul 1997 05:00:00 GMT");
header ("Last-Modified: " . gmdate("D,d M YH:i:s") . " GMT");
header ("Content-Description: PHP Generated Data" );
// Envia o conteÃºdo do arquivo
echo \$html;
exit;
``````

O exportar estÃ¡ funcionando.

Mas quero que fique com as bordas

## Maintaining InDesign formatting when updating a linked Excel file

I have a table that I’ve imported into InDesign with the ‘unformatted table’ box checked. I was of the understanding that this imported text only so that if I make a change to the text value only, it will automatically update in InDesign.

I’ve spent a lot of time formatting and resizing rows and columns for them all to resize when I update the table link.

Cell colours are not affected (which are when I relink it as a formatted table) but the typeface, type size revert and row heights shuffle around.

Is there any way of getting just the text to feed through dynamically with InDesign keeping all the formatting?