General Betting
There is currently 1 person viewing this thread.
Thanks in advance.
Column B contains names. Column E contains a corresponding number.
I can use countifs to determine how many times a name occurs, but I'd also like to tot up the corresponding value in Column E each time the specified name occurs in Column B.
Column B contains names. Column E contains a corresponding number.
I can use countifs to determine how many times a name occurs, but I'd also like to tot up the corresponding value in Column E each time the specified name occurs in Column B.
sort by:
Show
per page
Replies: 8
|
By:
Sounds as though a simple sumif would work.
As an example: =SUMIF(B5:B50,"Name1",E5:E50) |
|
By:
Copy and paste
=SUMIFS(B$1:B1,E$1:E1,B1) And fill down |
|
By:
A pivot table is neater.
|
|
By:
Sorry got it the wrong way round
=SUMIFS(E$1:E1,B$1:B1,B1) I really should test first! |
|
By:
The problem with sumifs in this situation is you end up with a lot of random numbers and you still need to find the last occurrence of the required value in column B to get the final total. I am ofcourse assuming the problem to be solved is a simple one.
IanP is right, a Pivot Table would be the tidiest way of solving the problem especially if you wanted the final total for all the values in column B rather than just 1. Its also the better solution if you want to do any extra analysis on the data and is far more flexible. |
|
By:
Cheers.
There are a lot of commands i've never used in Excel, but on my way home it occured to me that there was probably a Sumifs command. For speed i'll probably go for the Sumifs and look at the Pivot Table when I have more time. |
|
By:
http://www.youtube.com/user/ExcelIsFun
"Over 1200 Excel How To Videos. This site is intended to show you many Excel Efficiency Tricks so you can work faster, you can help others at work and you can save enough time to have extra vacation!" i really like this guy channel you have a lot of hidden gems there |
|
By:
oh!! just one suggestion...use the search uploads feature on you tube
|