Excel Halp

Thread replies: 12
Thread images: 1

Anonymous
Excel Halp 2016-10-09 17:23:15 Post No.
[Report] Image search: [Google]

File: urgent help.jpg (24KB, 150x385px) Image search: [Google]

Excel Halp Anonymous 2016-10-09 17:23:15 Post No. [Report]

How do I tell Excel to:

For each "male" in colum D, take its colum J value and add it up to a sum. The function should return 12, because that's all the "male" J values added together.

I'm really stuck on this one, any suggestions would make my day.

Anonymous 2016-10-09 17:24:05 Post No.56998371
[Report]

Anonymous 2016-10-09 17:24:05 Post No.56998371 [Report]

>>56998355
That's sexist.

Anonymous 2016-10-09 17:24:12 Post No.56998373
[Report]

Anonymous 2016-10-09 17:24:12 Post No.56998373 [Report]

>>56998355
start with googling it you fucking child

Anonymous 2016-10-09 17:25:05 Post No.56998393
[Report]

Anonymous 2016-10-09 17:25:05 Post No.56998393 [Report]

pivot table

Anonymous 2016-10-09 17:27:04 Post No.56998417
[Report]

Anonymous 2016-10-09 17:27:04 Post No.56998417 [Report]

>>56998371
that's ableist

Anonymous 2016-10-09 17:28:28 Post No.56998440
[Report]

Anonymous 2016-10-09 17:28:28 Post No.56998440 [Report]

>>56998371
joke's on you, I'm a femanon. Females can't be sexist :^)

>>56998373
I tried, I'm not even sure what exactly to google.

>>56998393
Never heard of it, but I'll look into it. I don't want to creata graph, I just want a function that results in a number.

Anonymous 2016-10-09 19:20:52 Post No.57000177
[Report]

Anonymous 2016-10-09 19:20:52 Post No.57000177 [Report]

>>56998355
write a macro
they use VB btw

Anonymous 2016-10-09 19:22:20 Post No.57000197
[Report]

Anonymous 2016-10-09 19:22:20 Post No.57000197 [Report]

>>56998355
Fuck you

Anonymous 2016-10-09 19:25:48 Post No.57000232
[Report]

Anonymous 2016-10-09 19:25:48 Post No.57000232 [Report]

Sumif function?

Anonymous 2016-10-09 19:30:26 Post No.57000298
[Report]

Anonymous 2016-10-09 19:30:26 Post No.57000298 [Report]

>>56998355
SUMIF might be your friend

Anonymous 2016-10-09 21:14:54 Post No.57001764
[Report]

Anonymous 2016-10-09 21:14:54 Post No.57001764 [Report]

>>56998355

yep, Sumif()

Anonymous 2016-10-09 21:47:08 Post No.57002220
[Report]

Anonymous 2016-10-09 21:47:08 Post No.57002220 [Report]

Bitch never even thanked us. Mods pls ban OP.

I'm aware that Imgur.com will stop allowing adult images since 15th of May. I'm taking actions to backup as much data as possible. Read more on this topic here - https://archived.moe/talk/thread/1694/

I'm aware that Imgur.com will stop allowing adult images since 15th of May. I'm taking actions to backup as much data as possible.
Read more on this topic here - https://archived.moe/talk/thread/1694/