Monday, November 15, 2010

EXCEL Tip of the Day

Summing with error terms:
If you use the normal SUM formula, you will get #N/A. To find out the total of the values, you have to use the SUMIF formula =SUMIF(B2:B10,"<>#N/A"), assuming that the range is from B2 to B10

No comments:

Post a Comment

Note: Only a member of this blog may post a comment.