Register now or log in to join your professional community.
answer :we use the SUMIF function to sum the values in a range that meet criteria that you specify. For example, suppose that in a column that contains numbers, we want to sum only the values that are larger than5. we can use the following formula:
=SUMIF(w2:w,">5")
Answer : we can use "IFERROR" funcation in this problem
