Formula

[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?

 

[T. Valko]

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

 

[David Biddulph]

Make that =SUM(D45,F45,G45)=SUM(E45,H45:M45)
if that's what the OP wants.

 

[T. Valko]

I thought I saw a comma!