Forum Discussion

kborowy's avatar
kborowy
Copper Contributor
Jan 09, 2024
Solved

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...
excel
Formulas and Functions
  • Harun24HR's avatar
    Harun24HR
    Jan 09, 2024

    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.

kborowy's avatar
kborowy
Copper Contributor
Jan 09, 2024

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.

Harun24HR's avatar
Harun24HR
Bronze Contributor
Jan 09, 2024

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.

  • kborowy's avatar
    kborowy
    Copper Contributor
    Jan 09, 2024
    Thank you! That explains it.

Resources