Excel formula is not working

Help Something Else
1

Filteredcombo.xlsx (8.9 KB)

image
image1166×210 12.1 KB

this formula is not working =M2/SUMIFS(H:H,L:L,L2)*H2 in q2 cell

if i remove delimiter it is working so how to make it work without removing delimiter

2

@Sathish_Kumar5,

It’s your formula issue not an UiPath issue. Try to search it on google for correct formula.

Thanks,
Ashok :slight_smile:

3

actually sorry i forgot to add L column so please check now

image
image1148×309 7.03 KB

4

shall i create new post?

5

@Sathish_Kumar5,

No need of it but I’m not understanding the issue.

6

Actually i have a excel which has delimeters without removing delimiters for h column and m column that formula is not working but after removing delimiters that formula is working please go through this ill share updated excel file

7

@Sathish_Kumar5,

It seems working at my side. See.

image
image1407×243 13.9 KB

Thanks,
Ashok :slight_smile:

8

yes, can you check this excel file
Filteredcombo.xlsx (8.9 KB)

9

@Sathish_Kumar5,

Ok so it’s happening due to numbers stored as text. See that warning on H column.

Solution:
Convert that to a number instead of text or string.

Excel Formula

Thanks,
Ashok :slight_smile: