sumifs function in Microsoft Excel and other equivalent software is used to sum up a range of cells following a condition match.
Few examples as below
sumifs(R2:R,L2:L,">=1%",R2:R,">0")
All cells of column R from R2 will be summed up only if the column L range from L2 to end of L column cells are greater than 1% and if column R range from R2 to end of R column cells are greater than 0
sumifs(R2:R,L2:L,"<>20",R2:R,">0")
All cells of column R from R2 will be summed up only if the column L range from L2 to end of L column cells are not equal to 20 and if column R range from R2 to end of R column cells are greater than 0
sumifs(R2:R,L2:L,"",R2:R,">0")
All cells of column R from R2 will be summed up only if the column L range from L2 to end of L column cells are blank and if column R range from R2 to end of R column cells are greater than 0