is there a way to write a formula that counts the number of rows, where the counts starts at offset(2,-1) from cell containing formula, and ends where the word "Annualized" Appears?
any help is much appreciated...
Thanks!!
I may not of given you enough info, I have attached a screen shot that may explain better, I need a formula that will count the number of rows in each group, the number of rows will vary and and sometimes a row will be deleted and the count need to update with new row count... hopefully the entire screen shot will help...
Thanks so much for the help!!
Which column do you want counted? S?
My formula is atill what you need just the references must be adjusted. I thougt your formula is in column R, now I see you want it in T.
Use this for the formula in T6:
I want a count of the rows between for the first group where the red cell is 2 this is counting how many rows starting down 2 and to the left 1 that are numbers in green, the end is always the cell with annualized, does this help, not column count row count...
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.