Countif backwards and autofill forward

Mistert271828

New Member
Joined
Dec 21, 2016
Messages
1
Hey. I am trying to figure out a formula that will countif backwards until 3 cells have been counted with various blank cells in between that I can autofill forward that will always just countif the most recent (from right to left) 3 cells. The if of the countif is just >=3.
W1W2W3W4W5W6W7W8W9W10
1325
formula here that i can autofill forward

<tbody>
</tbody>


So where the formula is in the table would return 2 and only count back to W4.

Thanks for the help!
 

Excel Facts

Can you AutoAverage in Excel?
There is a drop-down next to the AutoSum symbol. Open the drop-down to choose AVERAGE, COUNT, MAX, or MIN

Forum statistics

Threads
1,190,704
Messages
5,982,405
Members
439,777
Latest member
daleEH

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top