Google Sheets/ Data

How-to's for Google Sheets

Sheets_freezing and alternating.mp4

Freezing Rows and Columns

Coloring Alternating Rows

Conditional Formating.mp4

Conditional Formating (color coding)

Countifs.mp4

Countif sample codes

=countif(B5:B115,"5")
- - Count the amount of a certain number in the column
=countifs(D5:D115,">70",D5:D115,"<88")
- - Count the amount of numbers that falls into a certain range

Pivot Tables how to and uses for...

Report abuse