Stack Overflow
Stack Overflow

Questions tagged [subtotal]

The total of part of a series of numbers

398 questions
1
vote
1 answer

Calculation subtotal with if function

I have the following formula in a separate table to the below (below table is data set). However the results for the section are out by one section e.g. How can I get the licensing result in the…
Hoube78
  • 45
  • 6
1
vote
2 answers

Sum of samples received, sum of samples received 7 days ago, difference between two sums with total at bottom of column

I would like to create the following: Location Name Monday Last Monday Delta Location 2 90 92 -2 Location 4 76 71 5 Location 1 20 23 -3 Location 3 15 13 2 Total …
JohnnyBaltimore
  • 57
  • 1
  • 7
1
vote
2 answers

How do combine a random amount of lists in python

I'm working on a program that reads trough a FASTQ file and gives the amount of N's per sequence in this file. I managed to get the number of N's per line and I put these in a list. The problem is that I need all the numbers in one list to sum op…
Thije Zuidewind
  • 87
  • 1
  • 1
  • 7
1
vote
2 answers

SQL Server conditional subtotal query

given the following table: create table #T ( user_id int, project_id int, datum datetime, status varchar(10), KM int ) insert into #T values (1, 1, '20160301 10:25', 'START', 1000), (1, 1, '20160301 10:28',…
Gabor
  • 1,409
  • 1
  • 14
  • 24
1
vote
1 answer

Unable to AutoSum with LastCol in formula

Im having an issue writing VBA to Autosum where columns may increase or decrease from time to time. Take below as an example. I have set my LastCol to find the last column, i then want to autosum from column B on the row to the last column to get my…
Conor
  • 125
  • 1
  • 1
  • 15
1
vote
3 answers

SQL Server create grand total row

I have a table that contains order details. How can I create a row at the end that totals all my subtotals? SELECT o.order_id, o.itemDescription as Description, o.quantity_shipped as [Quantity], o.itemCost as [Price each], …
user2055729
  • 199
  • 1
  • 1
  • 13
1
vote
1 answer

Check excel column values if they are equal to each other

I have a table like this Product       Price     Currency ________   _____   ________ Product 1      10      USD Product 2      11      EUR Product 3      12      USD Product 4      13      CNY Product…
Farrukh
  • 11
  • 2
1
vote
4 answers

formula Subtotal 109 when hiding columns does not work in excel

I have formulas in column B which subtotal every other column starting with column E. So column E, G, I, K, M, O, Q, S, and eventually more. The formula in row 4 is =SUBTOTAL(109,E4,G4,I4,K4,M4,O4,Q4,S4) When I hide one of these columns the total…
KG869
  • 21
  • 1
  • 4
1
vote
1 answer

Use calculated cell reference in formula

I want to use SUBTOTAL to calculate the mean within a range without hard coding in the cell references. I an currently using the standard: =SUBTOTAL(1, A2:A11) But I want Excel to recognise which cells in column A start and end possessing values.…
TSG
  • 13
  • 4
1
vote
1 answer

How to find Grand Total in SSRS report

I developed a SSRS tabular report using below query select Department, CONVERT(DECIMAL(10,2), sum(si.GrossPrice) / 100.0) gross from SaleItem si, Sale sa where GrossPrice != 0 and sa.SaleID = si.SaleID and sa.StartDate between '2015-01-03…
Sachu
  • 7,555
  • 7
  • 55
  • 94
1
vote
3 answers

Sum of a strings array using C#

I am trying to build a console application using Web Services. Its use 2 functions. The first one GetAllProject outputs ptojectsID and ProjectsNames. The second function is GetUsersList and it outputs the list of users. Its need as a mandatory…
A arancibia
  • 281
  • 4
  • 5
  • 19
1
vote
0 answers

How do I break results sets into smaller subsets for subtotaling/hierarchical purposes in PHP?

I have some fairly sizable results sets being returned from a MySQL DB that I sometimes need to break into smaller sets for either: Adding together numbers within the subsets for subtotaling purposes; or For creating a hierarchical table. The…
HartleySan
  • 7,404
  • 14
  • 66
  • 119
1
vote
1 answer

Spotfire - Finding the percentage contribution of each Cell

I am trying to find the percentage contribution of each cell in a cross table in spotfire. The table looks like this Group Name Score 1 Andy 80 Bill 70 Charlie 90 2 Andre 100 Bob …
newb
  • 77
  • 1
  • 2
  • 8
1
vote
1 answer

COUNTIF with table filtering, or how does the SUMPRODUCT/SUBTOTAL/OFFSET combination actually work?

Given the following Excel table: +---+--------+----+----+ | | A | B | C | +---+--------+----+----+ | 1 | Filter | V1 | V2 | <-- header row of the table, with filtering option +---+--------+----+----+ | 2 | F1 | x | x | | 3 | F2 |…
sp00m
  • 47,968
  • 31
  • 142
  • 252
1
vote
2 answers

WPF data grid for financial style reporting?

I'm looking for a decent WPF data grid or solution involving one to represent financial data. I've looked at many - the WPF one, XCeed, Ingragistics, DevExpress, etc.... but none of them seem to offer the simple requirement I have: I want to be able…
Stephen Drew
  • 1,415
  • 19
  • 31
1 2 3
…
26 27