Try

=SUMPRODUCT(B18:B25*A18:A25)

this works for me too =sumif(B18:B25,true,A18:A25)

You need to adjust your ranges. Here's how =SUMIFS() works and then you'll see why you need to adjust the function.

=SUMIFS() looks for ranges and then applies the logic. So when you are telling the function to summarise E9:E14 it interprets it as:

SUM(E9,E10,E11,E12,E13,E14)

provided the following conditions. The conditions will tell the function whether to include each of the components (i.e. E9,...,E14).

Whether a condition is met or not is decided using a simple boolean (true/false) array. This could for example be I9:I14=FALSE which is interpreted as the array

{IF(I9=FALSE),IF(I10=FALSE),...,IF(I14=FALSE)}

resulting in an array similar to this:

{TRUE,TRUE,FALSE,FALSE,FALSE,TRUE}

(assuming the conditions I9, I10 and I14 are met but not the other three. The same is done for the second condition (the values in column H being equal to the value in G8, resulting in another array similar to this:

{TRUE,FALSE,FALSE,TRUE,FALSE,TRUE}

(assuming that only the values in H9, H12 and H14 are equal to G8.

When the function compares the two condition arrays and returns an aggregate array similar to this:

{TRUE,FALSE,FALSE,FALSE,FALSE,TRUE}

because only for the first and the last value the conditions are met. Therefore the =SUM function becomes like this:

SUM(E9,FALSE,FALSE,FALSE,FALSE,E14)

where FALSE = 0 so it returns

=SUM(E9,E14)

Here's where you get into trouble

You try to pass the function conditional arrays that are of a different size to the sum array (E9:E14), in effect asking it to compare apples and the age of your neighbour. What you need to do is to create the calculation you have in column E in a new column in rows 24 down and use that as the sum range in =SUMIFS().

Try using

=IF(I2=TRUE,J2*K2,H2*K2)

If you have a full range where you'll be doing this, try this

=ARRAYFORMULA(IF(ISBLANK(I2:I),,IF(I2:I=TRUE,J2:J*K2:K,H2:H*K2:K)))