I have a list of purchases made for the week on an excel sheet with the amount of money spent on each line.
How can I assign to a variable, the total sum of column “F”.
TotalPrice = 0
For each row: TotalPrice = TotalPrice + Convert.ToInt32(row.Item(5).ToString.Replace(",",""))
But kept getting 0 as the output.