Ask Your Question

How can I add a second condition to SUMIF? [closed]

asked 2012-11-06 09:56:47 +0100

PieterGoris gravatar image

updated 2015-10-18 22:42:49 +0100

Alex Kemp gravatar image


Can anyone help my building the correct formula? I am very newbie to this and I am having problems with building the formulas that I need. So any help from experienced users would be very appreciated.

Momentarily I came up with this:


This makes the sum from the currency fields in the range H69:H150 if, The category (textfield) within the range B69:B150 equals "Vrije tijd".

Now what I want is to add up an extra condition. I used SUMPRODUCT before but some more experienced users find that it's the wrong formula to use in my spreadsheet.

I want to add the extra condition to the SUMIF. Only do =SUMIF(B69:B150;A19;H69:H150) when the textfields in the range A69:A150 contain the word "Pieter".

Is there anyone who can help me building this formula since I don't see the light at the end of the tunnel. I don't even believe in the end of the tunnel anymore :p

This topic is a specified problem out of a larger one: []

The file I am talking about can also be downloaded there. The new formula with two conditions should be in the range B5:B19 from sheet '1112'.

Thank you very very much in advance for any help.

Greetz. Pieter

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-18 22:42:35.044210

2 Answers

Sort by » oldest newest most voted

answered 2012-11-07 01:41:31 +0100

m.a.riosv gravatar image

To work so, you need to enter the formula with Ctrl+Shift+Enter, to get an array formula.

Look in the help index for SUM() function.

edit flag offensive delete link more

answered 2012-11-06 20:14:25 +0100

PieterGoris gravatar image

I currently came up with this one but still get an 501 error. Anyone that can help me please?

=SUM(IF(A69:A150="Pieter",IF(B69:B150="Vrije tijd")))

edit flag offensive delete link more

Question Tools

1 follower


Asked: 2012-11-06 09:56:47 +0100

Seen: 2,275 times

Last updated: Nov 07 '12