SumIF for more than one condition
 

Hi,

I am wanting to sum up data in a column only when it corresponds to data in
2 other columns, i.e.

Stage Person Cost
Stage A Person 1 £5
Stage A Person 2 £2
Stage A Person 4 £8
Stage A Person 1 £7
Stage A Person 1 £10
Stage B Person 4 £12
Stage B Person 4 £1
Stage C Person 5 £3

What is the easiest way of calculating how much it costs for Person 1 in
Stage A? (actual spreadsheet contains hundreds of rows)

cheers,

SumIF for more than one condition
 

Hi Kippers,
Use Filter Option to know the amount, first filter by Person1
and then filter by Stage A. You will get a result.

Regards,
Vivek Mane

"kippers" wrote:

Hi,

I am wanting to sum up data in a column only when it corresponds to data in
2 other columns, i.e.

Stage Person Cost
Stage A Person 1 £5
Stage A Person 2 £2
Stage A Person 4 £8
Stage A Person 1 £7
Stage A Person 1 £10
Stage B Person 4 £12
Stage B Person 4 £1
Stage C Person 5 £3

What is the easiest way of calculating how much it costs for Person 1 in
Stage A? (actual spreadsheet contains hundreds of rows)

cheers,

SumIF for more than one condition
 

=SUMPRODUCT(--(A2:A10="Stage A"),--(B2:B10="Person 1"),C2:C10)

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"kippers" wrote in message
...
Hi,

I am wanting to sum up data in a column only when it corresponds to data
in
2 other columns, i.e.

Stage Person Cost
Stage A Person 1 £5
Stage A Person 2 £2
Stage A Person 4 £8
Stage A Person 1 £7
Stage A Person 1 £10
Stage B Person 4 £12
Stage B Person 4 £1
Stage C Person 5 £3

What is the easiest way of calculating how much it costs for Person 1 in
Stage A? (actual spreadsheet contains hundreds of rows)

cheers,

SumIF for more than one condition
 

One way:

=SUMPRODUCT((A2:A9="Stage A")*(B2:B9="Person 1")*C2:C9)

or with Stage A in D1 and Person 1 in E1:

=SUMPRODUCT((A2:A9=D1)*(B2:B9=E1)*C2:C9)

Note that you appear to have a double space in Person 1

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"kippers" wrote in message
...
Hi,

I am wanting to sum up data in a column only when it corresponds to data
in
2 other columns, i.e.

Stage Person Cost
Stage A Person 1 £5
Stage A Person 2 £2
Stage A Person 4 £8
Stage A Person 1 £7
Stage A Person 1 £10
Stage B Person 4 £12
Stage B Person 4 £1
Stage C Person 5 £3

What is the easiest way of calculating how much it costs for Person 1 in
Stage A? (actual spreadsheet contains hundreds of rows)

cheers,