The new forums will be named Coin Return (based on the most recent vote)! You can check on the status and timeline of the transition to the new forums here.
The Guiding Principles and New Rules document is now in effect.
Only if you can perform it without a transmutation circle; otherwise it's just tedious.
I never understood why there weren't more people with gloves or tattoos.
Each circle was specific so it had quite limited use. Saying that though, you'd still get a pair of gloves for the fairly common bits of alchemy you needed.
I look forward to the remake of the series, which may have already started.
Mojo_Jojo on
Homogeneous distribution of your varieties of amuse-gueule
CNN / the Jared Polis office just used one of my photos of US House Representative Jared Polis (D) (Colorado CD-2) who is a part of their "Freshmen Year" series where they follow two freshmen house reps around.
Only if you can perform it without a transmutation circle; otherwise it's just tedious.
I never understood why there weren't more people with gloves or tattoos.
Each circle was specific so it had quite limited use. Saying that though, you'd still get a pair of gloves for the fairly common bits of alchemy you needed.
I look forward to the remake of the series, which may have already started.
So why are they remaking it? I thought the series really said all it needed to with the current series and the movie follow up.
CNN / the Jared Polis office just used one of my photos of US House Representative Jared Polis (D) (Colorado CD-2) who is a part of their "Freshmen Year" series where they follow two freshmen house reps around.
Ummm, hey hey, so in Excel
If I have say, column A that is categories
And column B that is numbers
And say I want to sum up the numbers from B that all have the same corresponding category in A
Help?
SUMIF is what you're looking for here, basically. Let me know if you need more help.
[Edit]
VBA is, so far as I understand the situation, absolutely not necessary here.
Let me help you, Shaz. :P
LaOs help me
I understand how SUMIF works but how would I use it in this case
like say I have
A 1
A 2
A 4
A 5
B 6
B 6
B 4
C 7
C 8
and I need to sum up all of the ones that have A and all the ones that have B etc seperately (in my case A and B and whatnot are unique ID numbers)
You can either sort by the Category and then manually define the SUM areas, which is somewhat annoying but works well enough (especially for your example).
Or, you can use SUMIF. The key is, SUMIF is much easier if you already know or already have a list of what the different Categories actually are.
Anyway, you'd just have, in this example, three formulas: =SUMIF(A2:A10,"A",B2:B10) and =SUMIF(A2:A10,"B",B2:B10) and =SUMIF(A2:A10,"C",B2:B10)
Do you know the Categories (have a list of them, for example)?
CNN / the Jared Polis office just used one of my photos of US House Representative Jared Polis (D) (Colorado CD-2) who is a part of their "Freshmen Year" series where they follow two freshmen house reps around.
Ummm, hey hey, so in Excel
If I have say, column A that is categories
And column B that is numbers
And say I want to sum up the numbers from B that all have the same corresponding category in A
Help?
SUMIF is what you're looking for here, basically. Let me know if you need more help.
[Edit]
VBA is, so far as I understand the situation, absolutely not necessary here.
Let me help you, Shaz. :P
LaOs help me
I understand how SUMIF works but how would I use it in this case
like say I have
A 1
A 2
A 4
A 5
B 6
B 6
B 4
C 7
C 8
and I need to sum up all of the ones that have A and all the ones that have B etc seperately (in my case A and B and whatnot are unique ID numbers)
You can either sort by the Category and then manually define the SUM areas, which is somewhat annoying but works well enough (especially for your example).
Or, you can use SUMIF. The key is, SUMIF is much easier if you already know or already have a list of what the different Categories actually are.
Anyway, you'd just have, in this example, three formulas: =SUMIF(A2:A10,"A",B2:B10) and =SUMIF(A2:A10,"B",B2:B10) and =SUMIF(A2:A10,"C",B2:B10)
Do you know the Categories (have a list of them, for example)?
Hmm, I made a new column using a filter which therefore creates a unique list of categories which I am using as the middle input, but something is screwy... because my results are all the same.
EDIT: Nevermind, I think its working
thanx
Shazkar Shadowstorm on
poo
0
Zen VulgarityWhat a lovely day for teaSecret British ThreadRegistered Userregular
edited June 2009
Podly you called me an asshole a few days ago and never apologized.
Ummm, hey hey, so in Excel
If I have say, column A that is categories
And column B that is numbers
And say I want to sum up the numbers from B that all have the same corresponding category in A
Help?
SUMIF is what you're looking for here, basically. Let me know if you need more help.
[Edit]
VBA is, so far as I understand the situation, absolutely not necessary here.
Let me help you, Shaz. :P
LaOs help me
I understand how SUMIF works but how would I use it in this case
like say I have
A 1
A 2
A 4
A 5
B 6
B 6
B 4
C 7
C 8
and I need to sum up all of the ones that have A and all the ones that have B etc seperately (in my case A and B and whatnot are unique ID numbers)
You can either sort by the Category and then manually define the SUM areas, which is somewhat annoying but works well enough (especially for your example).
Or, you can use SUMIF. The key is, SUMIF is much easier if you already know or already have a list of what the different Categories actually are.
Anyway, you'd just have, in this example, three formulas: =SUMIF(A2:A10,"A",B2:B10) and =SUMIF(A2:A10,"B",B2:B10) and =SUMIF(A2:A10,"C",B2:B10)
Do you know the Categories (have a list of them, for example)?
Hmm, I made a new column using a filter which therefore creates a unique list of categories which I am using as the middle input, but something is screwy... because my results are all the same.
EDIT: Nevermind, I think its working
thanx
Yeah, if you've got a list of the unique categories, replace "A" with a reference to that cell and it's golden. Remember to use Absolute referencing for the ranges if you're filling down the formula for all the categories in your unique list. It might appear to work if you forget this, but it's not actually pulling all the right numbers for all the categories in that case.
Only if you can perform it without a transmutation circle; otherwise it's just tedious.
I never understood why there weren't more people with gloves or tattoos.
Each circle was specific so it had quite limited use. Saying that though, you'd still get a pair of gloves for the fairly common bits of alchemy you needed.
I look forward to the remake of the series, which may have already started.
Yep. It's on Hulu.
Quid on
0
Podlyyou unzipped me! it's all coming back! i don't like it!Registered Userregular
So why are they remaking it? I thought the series really said all it needed to with the current series and the movie follow up.
The original show splits off from the manga's story and changes a good bit(which I haven't read). This one is supposed to be more faithful to the original source.
Waiting in the darkness.. You know never when Bama will strike..
Please he breathes so heavy, go on a treadmill you pudgy bastard!
I'll have you know that I often have to purposefully make noise just so I don't scare the shit out of people. One of these days I'm just going to start wearing a bell.
Each circle was specific so it had quite limited use. Saying that though, you'd still get a pair of gloves for the fairly common bits of alchemy you needed.
I look forward to the remake of the series, which may have already started.
So why are they remaking it? I thought the series really said all it needed to with the current series and the movie follow up.
They're remaking it because the series veered away from the manga pretty sharply when, uh, the family man dies. Also: $$$
It is out now and you can watch it subbed either from funimation, or Hulu. Hulu streams better but it's on something like a two week delay whereas funimation puts their stuff up a couple of days after it airs in japanland.
edit: DAMN YOU QUIIIID.
Tarranon on
You could be anywhere
On the black screen
0
LudiousI just wanted a sandwich A temporally dislocated QuiznosRegistered Userregular
edited June 2009
You sure Facebook didn't grab your contacts? It can do that you know.
Waiting in the darkness.. You know never when Bama will strike..
Please he breathes so heavy, go on a treadmill you pudgy bastard!
I'll have you know that I often have to purposefully make noise just so I don't scare the shit out of people. One of these days I'm just going to start wearing a bell.
I'm going to do that to my wife if only because 4 years of living with her, she still spooks me out.
Preacher on
I would like some money because these are artisanal nuggets of wisdom philistine.
Posts
SUMIF is what you're looking for here, basically. Let me know if you need more help.
[Edit]
VBA is, so far as I understand the situation, absolutely not necessary here.
Let me help you, Shaz. :P
morning, [chat]
I know a guy who says he's an alchemist.
The lengths people are willing to go to believe in things that aren't mainstream religions bewilders me.
I look forward to the remake of the series, which may have already started.
CNN / the Jared Polis office just used one of my photos of US House Representative Jared Polis (D) (Colorado CD-2) who is a part of their "Freshmen Year" series where they follow two freshmen house reps around.
http://www.cnn.com/2009/POLITICS/06/11/polis.charter.schools/index.html
So why are they remaking it? I thought the series really said all it needed to with the current series and the movie follow up.
Critical Failures - Havenhold Campaign • August St. Cloud (Human Ranger)
LaOs help me
I understand how SUMIF works but how would I use it in this case
like say I have
A 1
A 2
A 4
A 5
B 6
B 6
B 4
C 7
C 8
and I need to sum up all of the ones that have A and all the ones that have B etc seperately (in my case A and B and whatnot are unique ID numbers)
Nice photo, Mr. Fryer.
Hi [chat] thread. I'm not at work today. Going to to SF to see friends this weekend. Aw yeah.
You can either sort by the Category and then manually define the SUM areas, which is somewhat annoying but works well enough (especially for your example).
Or, you can use SUMIF. The key is, SUMIF is much easier if you already know or already have a list of what the different Categories actually are.
Anyway, you'd just have, in this example, three formulas: =SUMIF(A2:A10,"A",B2:B10) and =SUMIF(A2:A10,"B",B2:B10) and =SUMIF(A2:A10,"C",B2:B10)
Do you know the Categories (have a list of them, for example)?
Oh noes you know my last name now?....even though its in my signature :P
the internal library is down
now I have literally nothing
what about our love?
worse than nothing!
He said nothing, Podly. Nothing.
Haha, wasn't even thinking about your sig when I posted that. Grats on the photo, that's awesome!
EDIT: Nevermind, I think its working
thanx
Yeah, if you've got a list of the unique categories, replace "A" with a reference to that cell and it's golden. Remember to use Absolute referencing for the ranges if you're filling down the formula for all the categories in your unique list. It might appear to work if you forget this, but it's not actually pulling all the right numbers for all the categories in that case.
Please he breathes so heavy, go on a treadmill you pudgy bastard!
pleasepaypreacher.net
a) that baby is super duper cute
b) the little frenchie puppy that Tyson holds is super duper cute
so cute
I'm sorry, Zen. Really, I'm very sorry. Super sorry, even. Totally, unquenchably sorry.
Since all you're commenting on is the cuteness I can only assume that nothing else was noteworthy.
Facebook is making very strange friend recommendations.
One person has only been in contact with me by making comments on my blog, which generated an email sent to my Gmail account.
The other person I have only talked to on MSN.
This all happened within 24 hours of me trying Google Quick Search Bar.
Get the fuck out of my private sphere, Google. Also, how the FUCK did Facebook find out about this from Google? What's the link?
They're remaking it because the series veered away from the manga pretty sharply when, uh, the family man dies. Also: $$$
It is out now and you can watch it subbed either from funimation, or Hulu. Hulu streams better but it's on something like a two week delay whereas funimation puts their stuff up a couple of days after it airs in japanland.
edit: DAMN YOU QUIIIID.
On the black screen
It's actually more like that, yeah. But it's not like lines.
I'm going to do that to my wife if only because 4 years of living with her, she still spooks me out.
pleasepaypreacher.net