Indirect Function

Hello all. First of all, thank you for all of the help I've gotten from this site purely by searching, amazing!

My inquery....

I am trying to use an indirect function to count a range based off whether of not the values in these cells are positive or negative. I can manually type in the column start to finish for this; essentially:

"=countif(R69:R84,">0")"

Which works great if I want to go through thousands of cells to find the start and stop of each set of data which could be updated at any time by any person; so not a great way of doing this. So I instituted a column to figure out which row starts each data set, essentially data set 1, data set 2, etc. So data set 1 starts on Row 67 and data set 2 starts on Row 83 for example. I need to read the data from columns Q, R, S, etc... I've used indirect in the past to read the data from a certain cell to another. So if I want the data from Q67 and I'm in column BQ, I'd write indirect(BQ&67) which displays the data from Q67. Well I need indirect to read the data from Q67 from the column I set up to display the row number.

So I tried "=countif(indirect(BQ$32&BO66:BQ$32&BN67),"<0")" (where BN67 is just BO-1 so I can have it read from the row before the start of the next set) which of course outputs an error....what am I missing or not understanding?

Hi and welcome to the forum

i would suggest you upload a sample work book, (all sensitive data removed), showing what data you are working with, a few examples of what your expected outcome is, and how you arrived at that
To attach a file to your post,
click advanced (next to quick post),
scroll down until you see "manage file",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.