Only SUM from one sheet (Excel)

[#1]

Hello,

I have to sheets in excel. I have a ID in both of them. In the first sheet i have some data connected to it and in the second sheet i have description of what the ID means.

I want to make a chart showing the SUM of all ID. But i only want to SUM the ID from sheet 1. Because now when i go to SUM(ID) it will also include the one in sheet 2. Which is false, since they are only there so i can get a definition of the ID.

Hope you understand.

Regards,

Erik

[Anonymous · Accepted solution]

you should an additional Expression from sheet 1

load

id

id as Sheet1id

..

from excel

then you can use sum(Sheet1id) - do you want sum or Count?

there is no other way as QV does not know what ID you want

[#3]

OK nice, i tried to go with..

load

id as sheet1id

But that did not work..

But your solution

load

id

id as sheet1id

did work perfectly.

thank you!!