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

SuM function

Copper Contributor

I am using the SUM function to add the total of a row of cells not all of which have values.  Some cells are empty, some have $0.00 and some have an actual amount.  I have selected the entire row of cells. They are not adding up to the correct sum.  For example, a row that has 

30.0030.0030.0030.00

as well as several 0.00 and many blanks is coming with $210 as the total.

4 Replies
Your question doesn't make sense.
best response confirmed by Hans Vogelaar (MVP)
Solution

@Harun24HR 

 

never mind.  I found a circular error and corrected it.

No issue. So, your problem is solved?
yes
1 best response

Accepted Solutions
best response confirmed by Hans Vogelaar (MVP)
Solution

@Harun24HR 

 

never mind.  I found a circular error and corrected it.

View solution in original post