-->
🏠 🔍
SHAREOLITE

Excel Spread sheet sumifs sample examples

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

Excel Spread sheet sumifs sample examples

 

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

Comments

–>