summing data using VBA

[dakoris73]

Hello there;

I am working on a project for some call stats and QA figures, and am lost at trying to use VBA to calculate the functions that I need.

I am working with with three columns with many rows of data. The one column (column D) has the previous weeks totals; column E has the current weeks totals. in Column G, I am trying to find the difference between the two previous columns to show the improvements made, if any. The problem is that column E can contain the "0" (zero) or "Inactive" labels and this is causing a problem with the usual SUM feature. What I am wondering is if a VBA function or Macro is going to be needed to come up with the following thinking:

If row X; column E has "inactive" or "0", then print column D inside column G
Else
if row X; column E contains a number, then subtract column D from column E and print to Column G

The problem is that I don't know how to reference the particular columns within VBA for Excel, nor waht functions are needed. Can anyone help clear this up for me, or help me to create a starting point to create this feasability?

Thank you
Mikey
dakoris73

[Bob Phillips]

Why use VBA

in G

=IF(OR(E2=0,E2="Inactive"),D2,E2-D2)

--
HTH

Bob Phillips

(replace somewhere in email address with googlemail if mailing direct)

"dakoris73" <[email protected]> wrote
in message news:[email protected]...
>
> Hello there;
>
> I am working on a project for some call stats and QA figures, and am
> lost at trying to use VBA to calculate the functions that I need.
>
> I am working with with three columns with many rows of data. The one
> column (column D) has the previous weeks totals; column E has the
> current weeks totals. in Column G, I am trying to find the difference
> between the two previous columns to show the improvements made, if any.
> The problem is that column E can contain the "0" (zero) or "Inactive"
> labels and this is causing a problem with the usual SUM feature. What I
> am wondering is if a VBA function or Macro is going to be needed to come
> up with the following thinking:
>
> If row X; column E has "inactive" or "0", then print column D inside
> column G
> Else
> if row X; column E contains a number, then subtract column D from
> column E and print to Column G
>
> The problem is that I don't know how to reference the particular
> columns within VBA for Excel, nor waht functions are needed. Can anyone
> help clear this up for me, or help me to create a starting point to
> create this feasability?
>
> Thank you
> Mikey
> dakoris73
>
>
> --
> dakoris73
> ------------------------------------------------------------------------
> dakoris73's Profile:
http://www.excelforum.com/member.php...o&userid=34901
> View this thread: http://www.excelforum.com/showthread...hreadid=546414
>

[dakoris73]

Hello Bob;

Thank you for that little bit of code. That actually worked better than I thought it would. I guess I was looking at the problem as a much bigger issue that it is....

Thanks again

mikey
dakoris73