The total of part of a series of numbers
Questions tagged [subtotal]
398 questions
-3
votes
1 answer
Filter all brands that have total sales >500 units in the entire year
Data present for 2019 only
Brand
Date
Unit Sold
B1
20190101
10
B1
20190102
5
B1
20190103
100
B2
20190101
50
B2
20190103
500
Anu
- 1
- 1
-3
votes
1 answer
Excel VBA macro to select data based on date and move it to a new tab
I am hoping you can help me. I'm not great at vba and your community has been a great help in the past. I have to, on a monthly basis, run a report showing hours that are worked for my team on a a consulting project. Screen print…
ssue1216
- 3
- 3
-3
votes
5 answers
Finding % of Data
This is what my table looks like
Measure PT Name
Expired Mickey Mouse
Expired Donald Duck
Alive Big Bird
Alive Baby Bird
Rehab Daffy Duck
Xray Goofy
I want it to look like this:
Measure Count %
Expired 15 …
user3666224
- 71
- 4
-3
votes
1 answer
How do I calculate subTotal using one method and multiple constants and variables?
I'm just getting into java and have a program I need to write with a Class and ClassDriver. I'm supposed to write a program to calculate the total for cheesecake orders (four different kinds) based on price and count. The price given for each is…
Mr_Traum
- 11
- 3
-5
votes
1 answer
cbind arguments in large dataframe
I have searched unsuccessfully for several days for an answer to this question: I have a dataframe with 279 columns and want to generate subtotals using aggregate(), or indeed, anything suitable. Here is a subset:
LGA off.cat …
Ronald
- 15
- 4
-9
votes
1 answer
add row after each subtotal excel vba
I need a macro that will insert a row after each subtotal, please see picture below for desired result.
Gabe Carvajal
- 65
- 1
- 11