I think this is what you want...
=COUNTIF((INDIRECT("k"&G55):INDIRECT("k"&G54)),100)
Indirect is what will point what is in K and G55 to end up being the location of K10
I think this is what you want...
=COUNTIF((INDIRECT("k"&G55):INDIRECT("k"&G54)),100)
Indirect is what will point what is in K and G55 to end up being the location of K10
Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
Sam Capricci
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks