Friday, August 9, 2013

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   Aug, 9 2013
user Sales Avant (!mydiscussions/docs/je2vd6kH6yI)
Issue with sumif function - works in one sheet of a workbook but not in another sheet of same workbook!!

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.
I can share a sample sheet as an example, pls forward email id