Sumif in Uipath

Help Studio
1

Hi

I have two excels DT1 and DT2. DT2 has 4 columns and in 4th column i will be writing sumif formula.

What i have to sumif is…I have to take column"Wb" from Dt1,next column should be from Dt2 …column1 name as " DISALLOWED" and also column from DT1 which has name “IR”.

Could someone help me on this @ppr @Palaniyappan @vvaidya @ClaytonM @mickeymack @supermanPunch @Zac_Soh @MAHESH1 @kirankumar.mahanthi1 @mukeshkala @StefanSchnell @prasath_S

2

Hi @Satish_Ch

Could you explain ur query with screenshots , could not getting the ur query ?

Regards,
Nived N

2 Likes
3

i need to calculate = sumif(‘Final Report’!D:D,‘Disallowed’!B11,‘Final Report’!AL:AL)

Here final report and disallowed are two sheets in one excel…i need to write calculation in disallowed sheet in G column

4

so you need to copy the formula to all cells under G column upto data resides?

5

You can Use write cell for writing formula directly in Cells of G column.
Or You can use for each row and apply this formula for given column.
Or you can directly use macro code to apply formula.

6

Yes Nived

7

@Satish_Ch
Then use write cell as specified by @ImPratham45

8

better to use invoke code with microsoft interop excel it will fasten up the speed of processing

9

We are not allowed to use invoke code.
Could you tell me how to write this with linq query if possible

10

We cant use for loop as this will take time and macros as suggested by client not to use.

Could you let me know if we can write linq query for this.

11

@Satish_Ch

Try VBA

link : Apply formula to entire column with a macro in VBA | MrExcel Message Board

12

Will try

1 Like
13

Its not working.Can u help me with the linq query for this.

14

Does anyone provide me the linq query for this.

15

Could you help me how to write this directly into writecell
And how to write it if i use datatables to store first

16

Can you share what you wrote in given screenshot. As i am not getting any error

image

17

I cant use hardcorded values like this …so i will be storing it in datatable first…finalreport as dt1 and disallowed as dt2

For that i need syntax

18

whatever you wrote in write cell please give me that string

19

Screenshot is having the string bro already

where Finalreport is one sheet name and disallowed is another sheetname

20

store them in String variable not in Datatable

1 Like