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 trial

Data Analysis

Posted by Dilwar Rahman
Dilwar Rahman
3,750 Points

In 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
KRIS NIKOLAISEN
54,970 Points

An 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
Dilwar Rahman
3,750 Points

Hi, thanks I tried a similar formula I must have got mixed up someway along the line, however thanks for your help much appreciated.