Monday, August 27, 2012

How to sum a column that has "--" values.

How to sum a column that has "--" values.


Question:

The SUM formula at cell N2 results in "--"

This is because the CONTINUE function in E147 resulting from the VLOOKUP formula in E3 is yeilding a "--" (which is a result of the actions on the HTML Lookup sheet.)

Is there any way to get the sum formula to ignore errors and "--" results and sum the valid numerical results?




Solution:

Instead of =sum(N3:N162) , Try =SUM(FILTER(N3:N162;ISNUMBER(N3:N162)))

So to exclude all non-numerical values, Instead of using formula =SUM(F10:F15), you must use =SUM(FILTER(F10:F15;ISNUMBER(F10:F15)))

I hope this solution will help you out.


I hope the above solution will help you, and if you need more help then please do comment below on this blog itself I will try to help you out.

If this blog post was helpful to you, and if you think you want to help me too and make my this blog survive then please donate here: http://igoogledrive.blogspot.com/2012/09/donate.html 

Thanks,
Kishan,


No comments:

Post a Comment