yogi_Why SUMIF would not work -- Summing Values When Entries In Column To Be Summed Are TEXTual (instead of NUMERIC)

                                          Google Spreadsheet   Post  #1324
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Aug, 9 2013
user Sales Avant (http://productforums.google.com/forum/?zx=wamnp8f8gc6h#!mydiscussions/docs/je2vd6kH6yI)
Issue with sumif function - works in one sheet of a workbook but not in another sheet of same workbook!!
Hello,

I have a workbook with 2 sheets for maintaining stock-on-hand and inventory list. Both sheets has same function - sumif. My issue is this function works on one sheet but not in other. I tried everything from creating a fresh sheet to deleting and adding a column where the function was applied, apart from clearing all the formatting. However, nothing seems to work. Wondering whats going on with this. Any help / suggestions highly appreciated.

Thanks in advance.
Avant
I can share a sample sheet as an example, pls forward email id
---------------------------------------------------------------------------------------------------------------------------------------------------.