| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
summing multi entries
Ok so I have a spread sheet that looks like this.
Mary 1 David 5 Paul 2 David 1 David 2 Paul 8 Josh 1 How do I get all Davids to sum together without subtotaling and screwing up my page format? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
summing multi entries
=SUMIF(A1:A10,"David",B1:B10)
HTH, Paul "Vtaylir" wrote in message ... Ok so I have a spread sheet that looks like this. Mary 1 David 5 Paul 2 David 1 David 2 Paul 8 Josh 1 How do I get all Davids to sum together without subtotaling and screwing up my page format? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
summing multi entries
=sumif(A1:A7,"David",B1:B7)
"Vtaylir" wrote: Ok so I have a spread sheet that looks like this. Mary 1 David 5 Paul 2 David 1 David 2 Paul 8 Josh 1 How do I get all Davids to sum together without subtotaling and screwing up my page format? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Summing List entries | Excel Discussion (Misc queries) | |||
| Summing List Entries 2 | Excel Discussion (Misc queries) | |||
| Summing the last 7 non-blank entries in a row of data | Excel Discussion (Misc queries) | |||
| How do I change multi-line entries to single line entries in Exce. | Excel Worksheet Functions | |||
Linear Mode
