Formula

  • Thread starter Thread starter kwright
  • Start date Start date
K

kwright

Trying to compare the sums of two groups of cells to ensure they are equal to
each other ie: d45,f45:g45 equal to e45,h45:m45. Have tried sum, sumif, if,
nested but can't seem to find the right formula. Any Help?
 
Try this:

=SUM(D45,F45,G45)=SUM(E45,H45,M45)

However, if those cells contain TEXT numbers the above formula will return
TRUE but that would be a "false positive". SUM ignores TEXT so it would
break down to:

=SUM(D45,F45,G45) = 0
=SUM(E45,H45,M45) = 0

0 = 0 = TRUE
 
Back
Top