- My Forums
- Tiger Rant
- LSU Recruiting
- SEC Rant
- Saints Talk
- Pelicans Talk
- More Sports Board
- Fantasy Sports
- Golf Board
- Soccer Board
- O-T Lounge
- Tech Board
- Home/Garden Board
- Outdoor Board
- Health/Fitness Board
- Movie/TV Board
- Book Board
- Music Board
- Political Talk
- Money Talk
- Fark Board
- Gaming Board
- Travel Board
- Food/Drink Board
- Ticket Exchange
- TD Help Board
Customize My Forums- View All Forums
- Show Left Links
- Topic Sort Options
- Trending Topics
- Recent Topics
- Active Topics
Started By
Message
Excel is easy to learn
Posted on 4/23/19 at 1:21 pm
Posted on 4/23/19 at 1:21 pm
Any way to do the following?
Column A has various 2-4 letter words or abbreviations (such as axx, cde, pm, etc).
Column B has numerical values for each instance of that particular item in column A. So we might have axx 5.2, axx (1.87) and axx 6.45 (each instance of axx is it's own row in column A and the corresponding numerical value is on same row in column B).
Im trying to find a way for excel to identify all cells with the same word/abbrev (such as axx) from column A and sum up the numerical values from column B and show the sum total in column C (maybe on same row as the largest instance of axx or the sum can be listed in column C for all rows containing axx (whatever might be easier or possible).
Hopefully this dumb frick explained clearly enough.
Anyone?
Column A has various 2-4 letter words or abbreviations (such as axx, cde, pm, etc).
Column B has numerical values for each instance of that particular item in column A. So we might have axx 5.2, axx (1.87) and axx 6.45 (each instance of axx is it's own row in column A and the corresponding numerical value is on same row in column B).
Im trying to find a way for excel to identify all cells with the same word/abbrev (such as axx) from column A and sum up the numerical values from column B and show the sum total in column C (maybe on same row as the largest instance of axx or the sum can be listed in column C for all rows containing axx (whatever might be easier or possible).
Hopefully this dumb frick explained clearly enough.
Anyone?
This post was edited on 4/24/19 at 8:36 pm
33
Posted on 4/23/19 at 1:22 pm to The Mick
quote:
need your help with a sum issue....
It’s either “some issues” or “a issue”. Take your millennial spelling back to reddit
This post was edited on 4/23/19 at 1:23 pm
Posted on 4/23/19 at 1:22 pm to The Mick
Insert the office/OT 350 response gif here.
Posted on 4/23/19 at 1:23 pm to The Mick
parameters
Posted on 4/23/19 at 1:24 pm to The Mick
Pivot table
Posted on 4/23/19 at 1:24 pm to The Mick
Put it all in a pivot table and make column A your filter
Posted on 4/23/19 at 1:25 pm to The Mick
Seems like you could do a pivot table where your column is the identifier in A and sum of column B, but maybe I don’t understand the question
Posted on 4/23/19 at 1:25 pm to The Mick
Sort the column in question and it will place all cells with like characters next to each other.
Posted on 4/23/19 at 1:26 pm to Dire Wolf
quote:
“a issue”.
"an issue" you old fart
Posted on 4/23/19 at 1:26 pm to bpinson
quote:And then...?
Sort the column in question and it will place all cells with like characters next to each other
Posted on 4/23/19 at 1:26 pm to Dire Wolf
quote:
“a issue”
"an issue"
I always find it entertaining when someone insults another person on here for bad grammar or spelling while making a mistake themselves.
Never change OT.
This post was edited on 4/23/19 at 1:28 pm
Posted on 4/23/19 at 1:27 pm to The Mick
Sumifs & Countifs are your friends.
Google the examples from Ablebits. They are outstanding.
Google the examples from Ablebits. They are outstanding.
Posted on 4/23/19 at 1:27 pm to The Mick
I'm working on a formula now
(f2*u4)+c6(k13-o8+f18*f3)
(f2*u4)+c6(k13-o8+f18*f3)
Posted on 4/23/19 at 1:27 pm to leftovergumbo
quote:How hard is that to set up?
Pivot table
Posted on 4/23/19 at 1:28 pm to Dire Wolf
quote:
It’s either “some issues” or “a issue”
?
Posted on 4/23/19 at 1:28 pm to The Mick
YouTube pivot tables of you don’t know anything about them.
But it’s a whole nuther skill to learn, not just a one off.
But it’s a whole nuther skill to learn, not just a one off.
This post was edited on 4/23/19 at 1:29 pm
Posted on 4/23/19 at 1:29 pm to The Mick
Something like.....
=Sumif($A1:$A100, "axx", B1:B100)
=Sumif($A1:$A100, "axx", B1:B100)
Posted on 4/23/19 at 1:29 pm to The Mick
Youtube a Pivot table.
They're easy as frick and very useful
They're easy as frick and very useful
Posted on 4/23/19 at 1:30 pm to The Mick
Sumif
Posted on 4/23/19 at 1:30 pm to The Mick
In C1: sumif($a$1:$a$10000,a1,$b$1:$b$10000) then fill down
Or just use a pivot table
Or just use a pivot table
Page 1 of 6
Back to top
Follow TigerDroppings for LSU Football News