Forum Discussion

kborowy's avatar
kborowy
Copper Contributor
Jan 09, 2024

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-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!

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

Share

Resources