Ask Geoff About Excel (or Google Sheets)

Health insurance rip off lying FDA big bankers buying
Fake computer crashes dining
Cloning while they're multiplying
Fashion shoots with Beck and Hanson
Courtney Love, and Marilyn Manson
You're all fakes
Run to your mansions
Come around
We'll kick your ass in

Postby creedence tapes » Fri Jun 01, 2018 6:43 pm

Just wanted to drop in and say that I started a job a week and a half ago where all I do all day is look at excel!! Thanks for the encouragement earlier in the thread.
creedence tapes
 
Posts: 2337
Joined: Sun Jun 09, 2013 12:27 pm

Postby Geoff » Fri Jun 01, 2018 6:47 pm

cool, good luck with your new job, and if you ever need any help you know where to go :)
User avatar
Geoff
i like jazz
 
Posts: 5514
Joined: Sat Dec 26, 2009 8:33 am

Postby Geoff » Fri Jun 01, 2018 6:47 pm

I also use google sheets a ton now that i work for a startup.
User avatar
Geoff
i like jazz
 
Posts: 5514
Joined: Sat Dec 26, 2009 8:33 am

Postby Night porter » Fri Jun 15, 2018 11:05 am

Hi Geoff, I have a probably (hopefully) easy excel question to answer:

I have two columns with totals at the bottom (=sum(j220:j228) for example.

I want a third total colum which total 1 + (total 2 x 2) =

So basically, it’s a points tally system but every score in the second column is worth 2points. Also I’d like another total at the end which divides the 3rd total by the amount of team members (rows)
User avatar
Night porter
 
Posts: 3773
Joined: Thu Dec 19, 2013 3:43 am
Location: the ditch

Postby Geoff » Fri Jun 15, 2018 11:17 am

does your total at the bottom have a column label "total"? are the totals all in the same column or different columns?
User avatar
Geoff
i like jazz
 
Posts: 5514
Joined: Sat Dec 26, 2009 8:33 am

Postby Night porter » Fri Jun 15, 2018 11:19 am

atm it looks like this

Night porter
Geoff
Total 0 0
User avatar
Night porter
 
Posts: 3773
Joined: Thu Dec 19, 2013 3:43 am
Location: the ditch

Postby Night porter » Fri Jun 15, 2018 11:20 am

Basically I just want a formula for cell1 plus cell2 x2
User avatar
Night porter
 
Posts: 3773
Joined: Thu Dec 19, 2013 3:43 am
Location: the ditch

Postby Geoff » Fri Jun 15, 2018 11:22 am

couldn't it just be cell1 + (cell2 x 2)?
User avatar
Geoff
i like jazz
 
Posts: 5514
Joined: Sat Dec 26, 2009 8:33 am

Postby Night porter » Fri Jun 15, 2018 11:22 am

I think I’ll just enter the data in column 2 in 2s rather than 1s
User avatar
Night porter
 
Posts: 3773
Joined: Thu Dec 19, 2013 3:43 am
Location: the ditch

Postby Night porter » Fri Jun 15, 2018 11:24 am

Geoff wrote:couldn't it just be cell1 + (cell2 x 2)?



How do you write that in the formula box?

I’m trying =SUM(J17:K17x2) and it doesn’t like it
User avatar
Night porter
 
Posts: 3773
Joined: Thu Dec 19, 2013 3:43 am
Location: the ditch

Postby Night porter » Fri Jun 15, 2018 11:26 am

X is * isn’t it
User avatar
Night porter
 
Posts: 3773
Joined: Thu Dec 19, 2013 3:43 am
Location: the ditch

Postby Night porter » Fri Jun 15, 2018 11:34 am

Sorted, thanks
User avatar
Night porter
 
Posts: 3773
Joined: Thu Dec 19, 2013 3:43 am
Location: the ditch

Postby Geoff » Fri Jun 15, 2018 11:51 am

if you want to do it one formula it is possible to do this with a sum product like SUMPRODUCT(A1:A7+B1:B7*2) if you didn't have a subtotal.
User avatar
Geoff
i like jazz
 
Posts: 5514
Joined: Sat Dec 26, 2009 8:33 am

Postby Geoff » Thu Jul 12, 2018 4:16 am

how many people use google sheets more than excel now?
User avatar
Geoff
i like jazz
 
Posts: 5514
Joined: Sat Dec 26, 2009 8:33 am

Postby kid8 » Thu Jul 12, 2018 4:17 am

Look, geoff, how do you add mintes and seconds?
This sucker's electrical.
User avatar
kid8
killer
 
Posts: 43651
Joined: Mon Dec 14, 2009 5:08 pm
Location: Normal Heights.

Postby kid8 » Thu Jul 12, 2018 4:18 am

I need to track my fucking calls.
This sucker's electrical.
User avatar
kid8
killer
 
Posts: 43651
Joined: Mon Dec 14, 2009 5:08 pm
Location: Normal Heights.

Postby Geoff » Thu Jul 12, 2018 4:24 am

Hi kid8, welcome to the thread.

Let's say if your time is in cell A1

To add x minutes would be A1 + Time(0,x,0)

To add x seconds would be A1 + Time(0,0,x)

So if you wanted to add 5 minutes and 30 seconds to a time in a cell it would be A1 + Time(0,5,30)
User avatar
Geoff
i like jazz
 
Posts: 5514
Joined: Sat Dec 26, 2009 8:33 am

Postby kid8 » Thu Jul 12, 2018 4:27 am

I also need an average of said times. I'm traking averages here.
This sucker's electrical.
User avatar
kid8
killer
 
Posts: 43651
Joined: Mon Dec 14, 2009 5:08 pm
Location: Normal Heights.

Postby kid8 » Thu Jul 12, 2018 4:27 am

Hi geoff.
This sucker's electrical.
User avatar
kid8
killer
 
Posts: 43651
Joined: Mon Dec 14, 2009 5:08 pm
Location: Normal Heights.

Postby Geoff » Thu Jul 12, 2018 4:29 am

kid8 wrote:I also need an average of said times. I'm traking averages here.


As long as the cells are in time format you can just use average(range)
User avatar
Geoff
i like jazz
 
Posts: 5514
Joined: Sat Dec 26, 2009 8:33 am

Postby kid8 » Thu Jul 12, 2018 4:32 am

Uggh, look geoff, send me a done deal where I can be like "this call lasted 8m 39s", and then the next one is like "4m 10s" and so on, then at the end of the day I'm like, " my shit is on point.
This sucker's electrical.
User avatar
kid8
killer
 
Posts: 43651
Joined: Mon Dec 14, 2009 5:08 pm
Location: Normal Heights.

Postby Geoff » Thu Jul 12, 2018 4:40 am

kid8 wrote:Uggh, look geoff, send me a done deal where I can be like "this call lasted 8m 39s", and then the next one is like "4m 10s" and so on, then at the end of the day I'm like, " my shit is on point.


does that mean you have the start and end times for each call?
User avatar
Geoff
i like jazz
 
Posts: 5514
Joined: Sat Dec 26, 2009 8:33 am

Postby kid8 » Thu Jul 12, 2018 4:42 am

No, I have the exact minutes and seconds each call lasts, need to add them up and then average them for the day. Thnx in advance
This sucker's electrical.
User avatar
kid8
killer
 
Posts: 43651
Joined: Mon Dec 14, 2009 5:08 pm
Location: Normal Heights.

Postby Geoff » Thu Jul 12, 2018 4:44 am

kid8 wrote:No, I have the exact minutes and seconds each call lasts, need to add them up and then average them for the day. Thnx in advance


can you just use average on all the exact times?
User avatar
Geoff
i like jazz
 
Posts: 5514
Joined: Sat Dec 26, 2009 8:33 am

Postby kid8 » Thu Jul 12, 2018 4:45 am

How do you do that?
This sucker's electrical.
User avatar
kid8
killer
 
Posts: 43651
Joined: Mon Dec 14, 2009 5:08 pm
Location: Normal Heights.

Postby kid8 » Thu Jul 12, 2018 4:46 am

Send me a template.
This sucker's electrical.
User avatar
kid8
killer
 
Posts: 43651
Joined: Mon Dec 14, 2009 5:08 pm
Location: Normal Heights.

Postby Geoff » Thu Jul 12, 2018 4:46 am

=Average(range of times you want to average)

If you times are stored in cells A1:A10, it would be average(A1:A10).

What kind of format is your call times in, it matters because you may need to convert it from text to time format first.
User avatar
Geoff
i like jazz
 
Posts: 5514
Joined: Sat Dec 26, 2009 8:33 am

Postby kid8 » Thu Jul 12, 2018 4:46 am

This sucker's electrical.
User avatar
kid8
killer
 
Posts: 43651
Joined: Mon Dec 14, 2009 5:08 pm
Location: Normal Heights.

Postby kid8 » Thu Jul 12, 2018 4:47 am

Send me the template.
This sucker's electrical.
User avatar
kid8
killer
 
Posts: 43651
Joined: Mon Dec 14, 2009 5:08 pm
Location: Normal Heights.

Postby kid8 » Thu Jul 12, 2018 4:47 am

You do it.
This sucker's electrical.
User avatar
kid8
killer
 
Posts: 43651
Joined: Mon Dec 14, 2009 5:08 pm
Location: Normal Heights.

PreviousNext

Return to Mamma Mia... Here We Go Again....

Who is online

Users browsing this forum: ahungbunny, alaska, anephric, Annie May, Boog Powell, buzzard, carrion, deebster, Dirty Penny, dreamshake, drudge, esmuydavista, fakename, Feech La Manna, fester, freshweed, fury, goldmatt, Google [Bot], Google Adsense [Bot], grace cathedral park, Grendel, guidance, hadlex, hiddenicon, Hideaway Lights, hideout, internethandle, jalapeño ranch, Jerry Lundegaard, jireland, kirito, lights, loaf angel, McNulty Just Farted, midnite cobra, Milk, naturemorte, palmer eldritch, Peptobysmal, pinkerton, quilty, REAL BASED SLOB, RedHots!, rich uncle skeleton, sassafras socks, ScaredGopher, scrambled, shrinemaidens, silverapples, Sissy Spacerock, slime, Sobieski, speakers, Steve & Co, surly, tgk, trouble, truncated, wakeman, wuk, Your Turret Has Been Destroyed, zach york