I want to basically do the following
= countif(k3:k130,"low")
the value of in cell d135 is k3, and the value in cell e135 is k130
so I tried
=countif(indirect("d135"&":"&"e135","low")
but that just returns zero. What am i doing wrong?
I want to basically do the following
= countif(k3:k130,"low")
the value of in cell d135 is k3, and the value in cell e135 is k130
so I tried
=countif(indirect("d135"&":"&"e135","low")
but that just returns zero. What am i doing wrong?
Formula:Please Login or Register to view this content.
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
yup... that worked! thanks!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks