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