Minus the results from the previous columns?

[phairplay]

Hi,

I'm using the below vba code to populate a value in the next empty for 12 difference rows


example:

Range("E6").End(xlToRight).Offset(0, 1).Value = "=COUNTIF('BoM Data'!C10,""Y"")"

what I would like to do is minus off all the previous results in the row after E6 so I can see how many "Y" have been added since it was last ran.


can someone please help

 

[Joe4]

I am a bit confused. In your formula, it looks like you are counting values from a different row on a different sheet.
(And it is odd to use COUNTIF on a single cell as opposed to a whole range).

Can you explain your data structure a bit more, and exactly what you are trying to do?
Post some images, if it helps in your description. You cannot upload files to this site. But there are tools you can use to post screen images. They are listed in Section B of this link here: Guidelines for Forum Use. Also, there is a Test Here forum on this board that you can use to test out these tools to make sure they are working correctly before using them in your question.

 

[phairplay]

Sorry I don't know why it's like that it looks for all "Y" in column J on another sheet

E6 has the starting result

When I run the above it will populates the countif in the next empty cell in row 6. What I would like it to do is sum up the previous results (D6:last used column) and remove it from the total so i can see how many more "Y" there are since the last time it ran.

 

[Joe4]

I am still not certain if I 100% follow, but see if this helps.

Here is an equation that will add a column at the end of row 6 to count all the "Y"s from column D to the last column (just before where it is inserting the value):

    Range("E6").End(xlToRight).Offset(0, 1).Value = "=COUNTIF(RC4:RC[-1],""Y"")"

Does that help?