I'm trying to use the value in a particular cell to help define a range. For example, I need the range to be =COUNTIFS(Sheet1!E2:E now here's where I want to use the value from cell Sheet2!L36, which is the active sheet. Ideas?
I'm trying to use the value in a particular cell to help define a range. For example, I need the range to be =COUNTIFS(Sheet1!E2:E now here's where I want to use the value from cell Sheet2!L36, which is the active sheet. Ideas?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks