Forum Discussion
SUMIFS Not Working
Can someone help explain why all my SUMIFS are resulting in 0? I am a newbie to this type of formula, but it seems like it is set up correctly. The formula in cell G2 is =SUMIFS(G:G, A:A, "00-11...
I am assuming, data in column are number values and formatted to 00-00000000-000000 but in formula you are using "00-11670000-71200" which is text and that is reason to get result as 0. Use actual account number in SUMIFS() argument. Share a sample file (attach a file).
Harun24HR Thanks for your response. I tried removing the quotes and I also tried putting it as a cell reference instead. Neither worked. I'm attaching the file.
