#1
|
|||
|
|||
Help with Excel(real quick and easy question)
Yo-
Here is what I need. I track data (bets) over a 4 month period and break it down weeek by week (and sport by sport). To keep it as simple as possible (i am not terribly swift) I just do a simple AutoFilter and sort by week. Heres my question. How do I do a SUM of the filtered data? I cant do a simple (h1:h14) because it grabs data I have no interest in. |
#2
|
|||
|
|||
Re: Help with Excel(real quick and easy question)
|
#3
|
|||
|
|||
Re: Help with Excel(real quick and easy question)
=Subtotal(9,CellStart:CellEnd)
|
#4
|
|||
|
|||
Re: Help with Excel(real quick and easy question)
Sublime, its actually a complicated thing to do. I have something similar, in that it separets bets using listboxes by sport, but i had to get a custome visual basic script written.
|
#5
|
|||
|
|||
Re: Help with Excel(real quick and easy question)
what you can do, although it's manual, is highlight the row after you apply the auto filter and right click the box on the bottom bar in the lower right that says "average = ..." and change it to sum (you can also change it to min, max, count, etc).
|
#6
|
|||
|
|||
Re: Help with Excel(real quick and easy question)
Help me first.
If I go to the store to buy Top Ramen, and know in the back of my mind that I like eating it uncooked more, which flavor should I buy? |
#7
|
|||
|
|||
Re: Help with Excel(real quick and easy question)
[ QUOTE ]
Help me first. If I go to the store to buy Top Ramen, and know in the back of my mind that I like eating it uncooked more, which flavor should I buy? [/ QUOTE ] chicken of course |
#8
|
|||
|
|||
Re: Help with Excel(real quick and easy question)
[ QUOTE ]
Help me first. If I go to the store to buy Top Ramen, and know in the back of my mind that I like eating it uncooked more, which flavor should I buy? [/ QUOTE ] Dude that [censored] is awful for you. |
#9
|
|||
|
|||
Re: Help with Excel(real quick and easy question)
[ QUOTE ]
[/ QUOTE ] The fact that I dont waste money on books like this probably explains why I am worth about 1000x more than you are [img]/images/graemlins/smile.gif[/img] |
#10
|
|||
|
|||
Re: Help with Excel(real quick and easy question)
[ QUOTE ]
The fact that I dont waste money on books like this probably explains why I am worth about 1000x more than you are [img]/images/graemlins/smile.gif[/img] [/ QUOTE ] Congratulations, dick! |
|
|