test 2 ranges
 

This should be simple but i can't see it.

How do I return TRUE/FALSE if the sum of 2 ranges are equal. The ranges are
different sizes (say) a1:a3 and b1:b6 so obviously I'm not looking at each
cell individually, just the sum of the ranges.

d

test 2 ranges
 

=SUM(A1:A3)=SUM(B1:B6)

If this post helps click Yes
---------------
Jacob Skaria


"Dave" wrote:

This should be simple but i can't see it.

How do I return TRUE/FALSE if the sum of 2 ranges are equal. The ranges are
different sizes (say) a1:a3 and b1:b6 so obviously I'm not looking at each
cell individually, just the sum of the ranges.

d

test 2 ranges
 

Hi,

The little used DELTA function

=DELTA(SUM(A1:A3),SUM(B1:B6))=1

Mike




"Dave" wrote:

This should be simple but i can't see it.

How do I return TRUE/FALSE if the sum of 2 ranges are equal. The ranges are
different sizes (say) a1:a3 and b1:b6 so obviously I'm not looking at each
cell individually, just the sum of the ranges.

d

test 2 ranges
 

Just a nitpicking caveat.

If the numbers are really TEXT numbers =SUM()=SUM() could return a false
positive. If the numbers are TEXT numbers then:

SUM() = 0 and SUM() = 0
0 = 0 = TRUE

--
Biff
Microsoft Excel MVP


"Jacob Skaria" wrote in message
...
=SUM(A1:A3)=SUM(B1:B6)

If this post helps click Yes
---------------
Jacob Skaria


"Dave" wrote:

This should be simple but i can't see it.

How do I return TRUE/FALSE if the sum of 2 ranges are equal. The ranges
are
different sizes (say) a1:a3 and b1:b6 so obviously I'm not looking at
each
cell individually, just the sum of the ranges.

d

test 2 ranges
 

Thanks Biff...

If this post helps click Yes
---------------
Jacob Skaria


"T. Valko" wrote:

Just a nitpicking caveat.

If the numbers are really TEXT numbers =SUM()=SUM() could return a false
positive. If the numbers are TEXT numbers then:

SUM() = 0 and SUM() = 0
0 = 0 = TRUE

--
Biff
Microsoft Excel MVP


"Jacob Skaria" wrote in message
...
=SUM(A1:A3)=SUM(B1:B6)

If this post helps click Yes
---------------
Jacob Skaria


"Dave" wrote:

This should be simple but i can't see it.

How do I return TRUE/FALSE if the sum of 2 ranges are equal. The ranges
are
different sizes (say) a1:a3 and b1:b6 so obviously I'm not looking at
each
cell individually, just the sum of the ranges.

d

test 2 ranges
 

Sorry to intrrupt,

quite confused after a test

A1:A3 = {2.1,2.3,2.4}
B1:B6 = {2.3,2.4,2.1,0,0,0}

testing formula
on C1 =SUM(A1:A3)=SUM(B1:B6) TRUE
on D1 =DELTA(SUM(A1:A3),SUM(B1:B6))=1 FALSE

Is there a simple explanation fo this varying test result-method.

regards,
"Mike H" wrote:

Hi,

The little used DELTA function

=DELTA(SUM(A1:A3),SUM(B1:B6))=1

Mike




"Dave" wrote:

This should be simple but i can't see it.

How do I return TRUE/FALSE if the sum of 2 ranges are equal. The ranges are
different sizes (say) a1:a3 and b1:b6 so obviously I'm not looking at each
cell individually, just the sum of the ranges.

d