Sum if 2 conditions hold true

[troop2118]

Hi there,

I am trying to find a way to get the sum of values if 2 conditions hold true.


Spreadsheet dimensions: A9-C3000

1st condition: Value in Column B is "GG1"
2nd condition: Value in Column C is lager then six and smaller or equal to 9.

For all events where this holds true, sum up the values in column C.

Thanks for you help

[icestationzbra]

see if this works for you.

=sumproduct((c9:c3000)*(b9:b3000="gg1")*(c9:c3000>6)*(c9:c3000<=9))

or

=sumifs(c9:c3000,b9:b3000,"gg1",c9:c3000,">"&6,c9:c3000,"<="&9)

[troop2118]

Thanks, but I get a #value error.

Could the reason be that in some of the cells in column C I have text. However, text is only on "non GG1" rows in column C. Any idea?

[troop2118]

I think I found a solution!

=SUMPRODUCT((C3:C15),--(B3:B15="gg1"),--(C3:C15>6),--(C3:C15<=9))

thanks

[icestationzbra]

SUMFIS would work around such datatype issues without the need for such coercion...