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