ExcelBanter - summing multi entries

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - summing multi entries (https://www.excelbanter.com/excel-discussion-misc-queries/149795-summing-multi-entries.html)

Vtaylir

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?

PCLIVE

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?

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?

All times are GMT +1. The time now is 09:30 PM.