Formula
 

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?

Formula
 

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

--
Biff
Microsoft Excel MVP


"kwright" wrote in message
...
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?

Formula
 

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

"T. Valko" wrote in message
...
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

--
Biff
Microsoft Excel MVP


"kwright" wrote in message
...
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?

Formula
 

I thought I saw a comma!

--
Biff
Microsoft Excel MVP


"David Biddulph" <groups [at] biddulph.org.uk wrote in message
...
Make that =SUM(D45,F45,G45)=SUM(E45,H45:M45)
if that's what the OP wants.
--
David Biddulph

"T. Valko" wrote in message
...
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

--
Biff
Microsoft Excel MVP


"kwright" wrote in message
...
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?