SUMIFS Not Working

[kborowy]

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-11670000-71200")

I would expect the result to be $6700.00 

The formula in cell H2 is =SUMIFS(H:H, A:A, "00-11670000-71200")

I would expect the result to be $2511.12

The cells are formatted as currency. If I make a simple formula of =SUM(G3:G11) in cell G2, it provides the correct answer.

Thanks for your help!

[#2]

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).

[#3]

@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.

[#4 · Accepted solution]

@kborowy Your formula is correct, but you have circular reference error. You can't refer same cell into formula where you are putting formula. See the attach file.

[#5]

Thank you! That explains it.