Forum Discussion
Auto Adding
Hey Guys
i am looking to make a task auto
hopefully, you can make sense of the idea below
column A has a list of names, say 200
Column b is a total amount
Column C I add a name from the list of column A (this can be multiple times in the rows)
Column d has a price that i insert
how do I make column B look at column C find the correct name in column A and add the price from column D to Column B
i have tried to make a table below with the idea
Cheers
dave
Column A Column B Column C Column D
dave 4,00 Jo 1,00
jane 0.00 jo 1,00
Pete 0.00 Dave 1,00
jess 1,00 jess 1,00
anna 0.00 Jo 1,00
jo 3,00 dave 1,00
dave 1,00
dave 1,00
7 Replies
oh my god that was so quick, thank you so much, i have no idea how you did that but it was exactly what i was looking for can I push my luck with one (ish) last question
how would i add more coloums to B
say columns C and D were January and columns E and F were February how do i add that to columns B as well
i tried this but didn't work
($C$2:$C$100;A2;$D$2:$D$100)+($E$2:$E$100;A2;$F$2:$F$100)
Cheers for the help
dave
You don't keep adding columns for different months. Instead create a single table, as you'll see I've done in this revised attachment, and you'll be able to add rows indefinitely, new names, new months, varied quantities.
And you switch to a Pivot Table to summarize it. Or at least, if I'm correctly hypothesizing where you're going with this. The Pivot Table is a very powerful and very popular tool that's been around for decades in the spreadsheet world. It's ideal for summarizing the kind of data you're starting to describe.
Create a single table, as I've done; you'll be able to add rows indefinitely, and Pivot Table will keep up with those additions (just need to use the "Refresh Data" capability which you've find on the Data Toolbar as well as in the Data menu (across the top).
If I misunderstood the direction you are going in, please come back and correct my understanding.
