How to sum and average the whole column

[emir_ozsimsir (emir özşimşir)]

Hello everyone,

I want to sum the data in the excel table in the picture, then I will take the average of this sum and print it in column C1 in the same excel file. what should I do?

note: the data in the excel file is printed as a string, not as int

I apologize for my bad English.

Project.zip (463.2 KB)

[Vikas_M]

@emir_ozsimsir

I want to sum the data in the excel table in the picture, then I will take the average of this sum and print it in column C1 in the same excel file. what should I do?

note: the data in the excel file is printed as a string, not as int

Hey @emir_ozsimsir , Please refer below file
BlankProcess1.zip (19.9 KB)

Hope it helps you !

[ppr (Peter Preuss)]

[HowTo] LINQ - First Start # Min | Max | Sum | Average Operator

This HowTo gives an introductory overview of the aggregation Operators: Min, Max, Sum, Average Introduction The aggregation operators are used to retrieve from a collection a particular result by setting the contained items into a relationship. Overview I – Input P – Processing O – Output {2,12,-8,6,14,5} get the lowest value -8 {2,12,-8,6,14,5} get the highest value 14 {2,12,-8,6,14,5} sum up all values 31 {2,12,-8,6,14,5} get the average of all values 5.17 Constraints P…

VB:
mySum | Datatype: Double = DtVar.AsEnumerable().Sum(Function (x) CDbl(x(“fiyat”).toString.Trim))

C#:

DtVar.AsEnumerable().Sum(x =>  Convert.ToDouble(x["fiyat"].ToString().Trim()))

[emir_ozsimsir (emir özşimşir)]

thank you very much sir it worked. but I cannot print it to excel because the data type is not data table, do you have any suggestions?

[Vikas_M]

You can use write cell activity and add it in the excel

Define the cell and it will write

[ppr (Peter Preuss)]

When the localization plays a role (dot is group seperator) we can do

Int32.Parse(YourString, System.Globalization.CultureInfo.CreateSpecificCulture("tr-TR"))
Double.Parse(YourString, System.Globalization.CultureInfo.CreateSpecificCulture("tr-TR"))

[emir_ozsimsir (emir özşimşir)]

I’m sorry, I don’t fully understand what exactly these codes are for, can you explain a little more?

[lrtetala (Lakshman Reddy)]

Hi @emir_ozsimsir

Please find below xaml for your reference

BlankProcess5.zip (164.0 KB)

O/P Excel:
FORD.xlsx (14.2 KB)

I hope it helps!!

[emir_ozsimsir (emir özşimşir)]

Thank you very much, this is exactly what I was trying to learn. can you explain why you are using if else?

[lrtetala (Lakshman Reddy)]

@emir_ozsimsir

Please find this xaml it contains two methods

BlankProcess5.zip (172.9 KB)

[lrtetala (Lakshman Reddy)]

@emir_ozsimsir

Method1:
In the given excel file it contains 1.100.000 so if we perform addition it doesn’t supports that’s why i am using if condition to filter it.

In 2nd method @ppr suggested conditions are helpful to read all values and performing addition.

So, better to use 2nd method because it reads all values to perform addition.

[emir_ozsimsir (emir özşimşir)]

I’ve learned a lot thanks to you