Homework help....2.0

Nem · Joined: 14 Apr 2008 Posts: 2108 Location: England

I believe you ought to be able to go

=SUM(A1:A158)

Wherein A is the letter of the column you're interested in
_________________
Never forget,
We stroll along the roof of hell
Gazing at flowers.
- Issa

Asa · Posted: Wed Aug 01, 2012 11:42 am Post subject:

Yes, but that's one column at a time. Granted, with some repetitive clicking I could get through each column rapidly. Do you, or does anyone, know a way to do multiple columns at once? "Columns A through XX, sum each column." That kind of thing.
_________________
Self-styled Forum Grandmother, because I hand out nicknames and hugs whether you want them or not. ^_^

Keeper of the Library and the Gateway to Haven

Nem: "It's the sort of face you just know is getting ready to poke you with something sharp."
BS: "...then insist you eat a brownie."
__________________
If we shadows have offended,
Think but this and all is mended...
Give me your hands if we be friends,
And Robin shall restore amends.

Nem · Joined: 14 Apr 2008 Posts: 2108 Location: England

Enter the formula as given above and copy the cell. (Not the formula.)

In the name box where it highlights the cell you've selected enter the range of the cells you want to fill the formula with - like B2:G2 or whatever - then paste. It ought, IIRC, to update the formula to reflect the cells above the relevant column automatically.

Failing that grab the lower right corner of the cells and drag them out and it should clone them properly.
_________________
Never forget,
We stroll along the roof of hell
Gazing at flowers.
- Issa

Asa · Posted: Wed Aug 01, 2012 2:45 pm Post subject:

Nem, the click and drag was exactly what I was looking for. Thank you!
_________________
Self-styled Forum Grandmother, because I hand out nicknames and hugs whether you want them or not. ^_^

Keeper of the Library and the Gateway to Haven

Nem: "It's the sort of face you just know is getting ready to poke you with something sharp."
BS: "...then insist you eat a brownie."
__________________
If we shadows have offended,
Think but this and all is mended...
Give me your hands if we be friends,
And Robin shall restore amends.

TheBritishInvasion · Joined: 23 Mar 2008 Posts: 1846 Location: The couch

Does anyone know anything about sculpting clay?

Specfically I'd like to know if you paint something before or after it's fired and how long it would take to fire a life sized sculpture of man.

It's for a book.
_________________
Britland as dubbed by AsA
Avatar courtesy of Footloose
Keeper of Tengu's electricity and Willow's 'what did you just say' eyes.

Claen'tor · Posted: Wed Apr 10, 2013 8:43 am Post subject:

Painting is done after first firing, but before glazing and second firing (which only occurs if you are glazing). That's about the extent of my pottery knowledge.

As for firing a life sized sculpture, I do not have personal experience to that end, and Google is failing me. :<

Edit: Did not realise I partially posted on the wrong thread. D:

Now Playing: U-Fig - System of a Down

This be Claen'tor, signing off.
_________________
Red is my colour. I live for it. Though it wears horribly on me. D;

I like to post my music. It's a habit. Be nice. ;_;

'People demand freedom of speech to make up for the freedom of thought which they avoid.'
-Soren Kierkegaard

Dubbed Clan by Asa
Claen'tor = Claen = Clan

Tinu. · Posted: Wed Apr 10, 2013 8:54 am Post subject:

It's after firing.

And I think that would probably take quite a while, and would depend on if it was hollow, or made entirely of clay.

I know some people who do sculpting, so I will ask them approximately how long that could be.
_________________
Keeper of Gaia and all the books on Earthsong

"If you judge a fish by its ability to climb a tree, it will spend its whole life believing it is stupid."
~Einstein