| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sum only specified values
Column A Column B
Joe 100 John 300 Bob 200 George 500 John 300 Bob 250 John 125 How do I get the sum of all entries for John in a cell in Column C? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Sum only specified values
Try this:
=SUMIF(A1:A7,"John",B1:B7) Or, use a cell to hold the criteria: D1 = John =SUMIF(A1:A7,D1,B1:B7) -- Biff Microsoft Excel MVP "Bob" wrote in message ... Column A Column B Joe 100 John 300 Bob 200 George 500 John 300 Bob 250 John 125 How do I get the sum of all entries for John in a cell in Column C? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Sum only specified values
Thanks, that did it!
"T. Valko" wrote in message ... Try this: =SUMIF(A1:A7,"John",B1:B7) Or, use a cell to hold the criteria: D1 = John =SUMIF(A1:A7,D1,B1:B7) -- Biff Microsoft Excel MVP "Bob" wrote in message ... Column A Column B Joe 100 John 300 Bob 200 George 500 John 300 Bob 250 John 125 How do I get the sum of all entries for John in a cell in Column C? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Sum only specified values
You're welcome!
-- Biff Microsoft Excel MVP "Bob" wrote in message ... Thanks, that did it! "T. Valko" wrote in message ... Try this: =SUMIF(A1:A7,"John",B1:B7) Or, use a cell to hold the criteria: D1 = John =SUMIF(A1:A7,D1,B1:B7) -- Biff Microsoft Excel MVP "Bob" wrote in message ... Column A Column B Joe 100 John 300 Bob 200 George 500 John 300 Bob 250 John 125 How do I get the sum of all entries for John in a cell in Column C? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Exclude #N/A values and Return Numeric values to consecutive cells in Single Row | Excel Worksheet Functions | |||
| Finding Most Recent Values in Col1 -- Summing Matching Values | Excel Discussion (Misc queries) | |||
| Adding numerical values based on multiple values in another column | Excel Worksheet Functions | |||
| Advanced Filter for Values in Column M greater than Values in Colu | Excel Discussion (Misc queries) | |||
| Excel Compare values in columns & display missing values in a new | Excel Discussion (Misc queries) | |||
![Bob[_13_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
