Automated Check box when a sum of cells is greater than another cell

Cheri J

I am trying to create a formula that checks the box if two cells are equal to one other cell. Getting so frustrated, please help! 🙏 This is the formula I have that is not working for me:

=IF(AND(TotalA@row, TotalR@row = TotalM@row, 1, 0))

What am I doing wrong?

Nic Larsen

Try this:

=IF(SUM(TotalA@row, TotalR@row) = TotalM@row, 1, 0)

SSFeatures

Hi Cheri, please try the following formula:

=IF(AND([Column2]@row = [Column4]@row, [Column3]@row = [Column4]@row), 1, 0)

I also noticed that in your formula one of your ")" is in the wrong location.

Before:

=IF(AND(TotalA@row, TotalR@row = TotalM@row, 1, 0))

After:

=IF(AND(TotalA@row, TotalR@row = TotalM@row), 1, 0)

Hope this helps!

Nic Larsen

Try this:

=IF(SUM(TotalA@row, TotalR@row) = TotalM@row, 1, 0)

Cheri J

Thank you so much @Nic Larsen !! That worked!!! 😊 I just spent soooooo much time on that. You're a lifesaver.