Welcome to the Treehouse Community
Want to collaborate on code errors? Have bugs you need feedback on? Looking for an extra set of eyes on your latest project? Get support with fellow developers, designers, and programmers of all backgrounds and skill levels here with the Treehouse Community! While you're at it, check out some resources Treehouse students have shared here.
Looking to learn something new?
Treehouse offers a seven day free trial for new students. Get access to thousands of hours of content and join thousands of Treehouse students and alumni in the community today.
Start your free trialDilwar Rahman
3,750 PointsIn the Retail Network spreadsheet you opened in the fourth quiz question, the number of cells with a value of “TRUE” in
Hi, ive tried numerous times reviewing the video using the count function however in the section L it is not a numerical value hence it would be 0, can anyone help me out with this. thanks
1 Answer
KRIS NIKOLAISEN
54,971 PointsAn easy way to get the answer is to sort L descending then take the row number (of the last true) - 1 (for the header). If you want to use a formula try countif as in:
=countif(L2:L8191,"TRUE")
where L2:L8191 is the range of cells and "TRUE" is the text to match.
Dilwar Rahman
3,750 PointsDilwar Rahman
3,750 PointsHi, thanks I tried a similar formula I must have got mixed up someway along the line, however thanks for your help much appreciated.