Working with multiple variables and columns

  • Hi,

    I have the following code with which I am getting error with the red text:

    It may be complicated so let me briefly explain. I am using the countifs function to get a number from a column from another sheet called "Pending Transactions Count" and subtracting another number from a different column from "Pending Transactions Count". Each countifs function has 2 criteria.

    I think my problem is in the way I have set up the variables and dimming them. Also I would like to repeat this formula for each dateCol column. Let me know if you have any questions.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!