How can I add a second condition to SUMIF?

Hi,

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:

=SUMIF(B69:B150;A19;H69:H150)

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 :stuck_out_tongue:

This topic is a specified problem out of a larger one: [Problems with refreshing data in chart]

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

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.

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”)))