Ask Your Question
0

Summing a range of cells [closed]

asked 2012-11-26 23:36:18 +0200

this post is marked as community wiki

This post is a wiki. Anyone with karma >75 is welcome to improve it.

I would like to sum a range - for example:

...A......B

1.John 1
2.Paul 2
3.Sue 1
4.Sue 3

sum(column B where column A = Sue) giving result 4 sum(column B where column A = Paul) giving result 2

Looks a bit like SQL really.

The only way I can think of getting round this is to create a "name" for each set of values in column A then sum(sue), sum(Paul) etc. This is a lot of work and it's horrible to use.

Edit: I have found that /Data/Define Range works a lot better for defining ranges, although it doesn't do the selection.

Is there a practical way of doing this?

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2015-10-19 02:53:56.022921

2 Answers

Sort by » oldest newest most voted
0

answered 2012-11-26 23:45:42 +0200

this post is marked as community wiki

This post is a wiki. Anyone with karma >75 is welcome to improve it.

=SUMIF(A1:A4;"Sue";B1)

edit flag offensive delete link more
0

answered 2012-11-27 00:03:11 +0200

this post is marked as community wiki

This post is a wiki. Anyone with karma >75 is welcome to improve it.

Mariosv - This looks like the right sort of thing, I'm trying it now.

edit flag offensive delete link more

Comments

Works perfectly - amazing you've saved me hours of frustration! I assume it's not necessary to put the range in the second part because it must match the first part, you are just telling which column to look at.

ChrisOfBristol gravatar imageChrisOfBristol ( 2012-11-27 00:11:55 +0200 )edit

Question Tools

Stats

Asked: 2012-11-26 23:36:18 +0200

Seen: 7,778 times

Last updated: Nov 27 '12