Rise Ranking

The SUMIF function in Google Sheets allows users to sum specific cells within a list. SUMIF is able to use exactly one criterion to determine if a value within a list should be summed or not. So How Does It Work? The SUMIF function requires at least 2 arguments to perform. A third argument may … Read more

Have you performed division calculations with a 0 in Google Sheets and get an answer “#DIV/0!”? Or perform a VLOOKUP and have many cells return with “#N/A”. While these results aren’t inaccurate, they are annoying to see and sometimes it’s better to use our own defined value for these cases. Luckily Google Sheets has included … Read more

Of all the functions in Google Sheets, the VLOOKUP, or Vertical Lookup, is one of the most confusing to new spreadsheet users and is somewhat of a rite of passage to learn. The VLOOKUP helps stitch existing and new data automatically without having you do it manually. In this article, we’ll break the VLOOKUP into … Read more

As a digital marketer, I struggle sometimes to find pieces of data within my MASSIVE Google Sheets spreadsheets. Rows begin to blend together once you have tens or hundreds of columns with data. Luckily you can help your eyes by implementing alternating rows to your spreadsheets. The easiest way to start alternating rows in your … Read more