The ADD IF function allows us to add the cells that meet certain conditions, thus discarding those that do not have those criteria