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