Any question answered...

I'd like to bring him into it. Have you read the story of the good Samaritan?

http://www.lfgss.com/thread190.html
http://www.lfgss.com/thread29899.html
http://www.lfgss.com/thread19719.html

Of course, posting their details to all of these would be spamming. How about you wait until someone asks about a metal polisher and then recommend them? That's how it usually works.

pah why do i bother, oh to creat a johnnyrau, lau whatever alias

What's the issue exactly?

What's the issue exactly?

tired, using this place as avoidance etc. might have nap

Just received a call from 0048609455474 but hung up by mistake. What sort of number is it?

A Polish number.

004 is the english code. So it's an english number starting with 08609. So it will be a call center.

044 is english..

Ha, shows how much I know.

Google spreadsheets. Why is this:

=sum(SUMIF(C14:C119,B3,G14:G119)),(SUMIF(J14:J119,B3,N14:N119))

giving me a circular dependency error?

C14:C119 and J14:119 = a team name. There will be 8 instances of this team name. G14:119 and N14:N119 are values (points, goals, goals scored, etc.). I want them added up.

I've used this formula before (last years polo league spreadsheet). It worked fine. Now, it works once, in one row. As soon as I add more instances (below) of the formula, it updates that row, but makes the one above fail.

Dear lord horatio, give up and use a pen!

I wish. It's a central spreadsheet that many people have access to and use to input the results of their games, which the main league page then uses to post the league standings. It's pretty simple stuff in the grand scheme of things, but it won't fucking do what it's supposed to.

Just guessing as I'm not a spreadsheet genius, but do you need another set of brackets?
i.e. =sum((SUMIF(C14:C119,B3,G14:G119)),(SUMIF(J14:J119, B3,N14:N119)))

Unfortunately not :( I think it's a good spreadsheets error though. It MAY be working now....

Seems to have stopped working again. Although now about half are reporting now errors (but have the same formula they used)? I don't get this.

giving me a circular dependency error?

Because it's a game with a hole in it?

Is the condition supposed to be the same for both SUMIF statements?

Are the formulae copying correctly? (Should you have a dollar sign before the B3 to keep it referring to the same cell?

Is the space before the B3 in the second statement breaking it (probably not).

Have you chcked that all the referenced cells have the correct content (numbers, text, etc).

Has anyone flown recently with Kuwait Air. I'm contemplating booking with them or United for an extra £65 pp.

A Polish number.

+1

Polish mobile number. 0048 and then 0605.

004 is the english code. So it's an english number starting with 08609. So it will be a call center.

You is tired probably and don't think straight

who distributes easton stuff in the UK ?
i am looking for a 2009 part which has been discontinued and need to see if they have any in their back room under all the boxes ?

Has anyone ever been to souvenir press opposite the british museum? was thinking of heading there for a present for the old man...

Google spreadsheets. Why is this:

[quote]
=sum(SUMIF(C14:C119,B3,G14:G119)),(SUMIF(J14:J119, B3,N14:N119))

giving me a circular dependency error?

C14:C119 and J14:119 = a team name. There will be 8 instances of this team name. G14:119 and N14:N119 are values (points, goals, goals scored, etc.). I want them added up.

I've used this formula before (last years polo league spreadsheet). It worked fine. Now, it works once, in one row. As soon as I add more instances (below) of the formula, it updates that row, but makes the one above fail.[/quote]

Screwed up brackets. Should look like this:

[code]
=SUM(SUMIF(C14:C119,B3,G14:G119),SUMIF(J14:J119, B3,N14:N119))
[/code]

Excel has better explanations for errors than G-Docs if you have access to a copy.

who distributes easton stuff in the UK ?
i am looking for a 2009 part which has been discontinued and need to see if they have any in their back room under all the boxes ?

http://www.eastoncycling.com/en-us/mountain/international-dealer/
Extra Uk Ltd
Datamex House, Morris Close
Park Farm Ind. Est., Wellingborough, Northants Nn8 6xf
44 (0) 1933 672 170
service@extrauk.co.uk
http://www.extra.co.uk

It's not the brackets. I'm pretty sure it's google.

Fuck Google.