Store current COUNTIFS value in each row in MS-Excel?

[silvercover]

I have a simple Excel file with some columns as you can see from here:

http://silvercover.ir/downloads/test.xlsx

I have a simple formula (COUNTIFS) to count occurrence of certain condition that I specified. everything works fine here, but I also need to write current value of count cell at the end of each qualified row.

Data entry is random and I may work on row 1 and then row 25, so incremental row numbers that is shown by excel is not my answer. I need exact number of occurrence for each qualified row.

excel.png

[akhileshgs]

can you pls upload a file with desired results too?

[Sam Capricci]

Yes, upload a sample with the desired results. I am not able to access your site link from my location.

[silvercover]

Here is my sample with desired results:

test.zip

[Sam Capricci]

ok, see your data, but there is a lot of missing information. You wrote ...

I have a simple formula (COUNTIFS) to count occurrence of certain condition that I specified. everything works fine here, but I also need to write current value of count cell at the end of each qualified row.

Data entry is random and I may work on row 1 and then row 25, so incremental row numbers that is shown by excel is not my answer. I need exact number of occurrence for each qualified row.

so what is a "qualified row" and what results are you looking for?