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
Do you need help in adding the right keywords to your CV? Let our CV writing experts help you.