Click here to Skip to main content
15,351,508 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Hi all,

i have an excel something like
id Status Profit
1 Pass 1
2 Fail 2
3 Pass 6
4 Fail 4
5 Pass 5

now i should read this using VB script and iterate through rows to get all the Pass value added and the Fail value added (sum of both) in status column
how can i achieve this using VB script
Thanks in advance

What I have tried:

i have written the code to access the excel how to iterate through it
Updated 13-Apr-19 4:17am
MadMyche 13-Apr-19 1:40am
Show us some code, so we know how the xl was read, and came aom you in the corrext direction
Richard MacCutchan 13-Apr-19 3:15am
Do you mean VB.NET or VBA?

1 solution

If you're doing this in Excel, you don't need to write a script. You can do it with formulas.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900