Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and the Yahoo Answers website is now in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.

Excel Help: Indirect()?

I am trying to decipher how to take the values of a cell and import them into a formula. I am reading online how to use the Indirect function, but I am having trouble getting it to work right.

right now I have a formula looking at a list of values in a table for the number of W in the column:

=COUNTIF(Sorted!$G$1:$G$7,"W")

The range on the cells are static. What I would like to do is take the numbers in the formula (the 1 and 7), place them in cells (in this case L1 and M1) and place the values into the formula and run it.

Psudo code would be something like this?

=INDIRECT('COUNTIF(Sorted!$G$ '+ L1 + ':$G$' + M1' + ',"W")')

I am not sure how to work this function at all. Any help would be appricated.

1 Answer

Relevance
  • FatGuy
    Lv 6
    9 years ago
    Favorite Answer

    if you make the row references relative vs absotule (change to $G1:$G7) then the rows will be changed automatically if you moved the formula to a different cell.

    INDIRECT creates a single cell reference, so you might need something more like

    =COUNTIF(INDIRECT("Sorted!$G"&$L$1):INDIRECT("$G"&$M$1),"W")

Still have questions? Get your answers by asking now.