Sumwhen(;;) Formula


#1

Hello,

i get an error by using the sumwhen function.


code [vb.net]:
xls.Worksheets(2).Cells(14, 18).Formula = “=SUMMEWENN($G$9:$G$32;$G33;H$9:H$32)”
or
xls.Worksheets(2).Cells(14, 18).Formula = “=SUMWHEN($G$9:$G$32;$G33;H$9:H$32)”

error:
Invalid formula:"=SUMMEWENN($G$9:$G$32;$G33;H$9:H$32)".
or
Invalid formula:"=SUMWHEN($G$9:$G$32;$G33;H$9:H$32)".

it is an german excel formula. When i use the english formula sumwhen it occurrs the same error.
the (german) formula is working fine when i manually copy it into a cell in excel.

any solution?


#2

Aspose.Excel only supports English formula. And I don’t find SUMWHEN formula in MS Excel. Maybe you should try SUMIF function.

xls.Worksheets(2).Cells(14, 18).Formula = “=SUMIF($G$9:$G$32;$G33;H$9:H$32)”