Copilot for Microsoft 365 Tech Accelerator
Feb 28 2024 07:00 AM - Feb 29 2024 10:30 AM (PST)
Microsoft Tech Community
SOLVED

SUMIFS Not Working

Copper Contributor

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.

 

kborowy_1-1704761371331.png

 

Thanks for your help!

4 Replies
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.

best response confirmed by kborowy (Copper Contributor)
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.

Thank you! That explains it.
1 best response

Accepted Solutions
best response confirmed by kborowy (Copper Contributor)
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.

View solution in original post