IF together with SUMIF


Is it possible to have an IF formula together with SUMIF? What is wrong with my formula below? Want to use one SUMIF formula if a cell says Style and another if the same cell says Variant.

IF($C$2=”Style”,SUMIF(‘Data NE’!A:A;A9;’Data NE’!G:G)),IF($C$2=”Variant”,SUMIF(‘Data NE’!B:B;B9;’Data NE’!G:G))


Kind regards


By: Cecilia

Leave a Reply

Your email address will not be published. Required fields are marked *