topic RE: BLUE PRISM EXCEL SUM IF in Product Forum

BLUE PRISM EXCEL SUM IF

LUZIOLECATHERIN — Sat, 21 Mar 2020 17:46:00 GMT

Hello,

I must use a formule SUM.IF in file EXCEL but i have a error message :

Internal : Could not execute code stage because exception thrown by code stage: Exception from HRESULT: 0x800A03EC

Thank

------------------------------
CATHERINE
------------------------------

RE: BLUE PRISM EXCEL SUM IF

sumire — Mon, 23 Mar 2020 07:33:00 GMT

like this?

inside of action:

result:

I got correct result without error.

I've seen the error "HRESULT: 0x800A03EC" when trying to open the Excel file while another application is using the same file.

------------------------------
Mitsuko
Asia/Tokyo
------------------------------

RE: BLUE PRISM EXCEL SUM IF

LUZIOLECATHERIN — Mon, 23 Mar 2020 11:15:00 GMT

HI Mitsuko,
It's OK.
I was putting ";" instead of "," and the word "SOME.IF" instead of "SUMIF" as i'm working on a Excel Version in French/
Thank you so much.

------------------------------
LUZIOLE CATHERINE
------------------------------