Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how copy formula that contains ranges so ranges do not overlap | Excel Worksheet Functions | |||
TEST | Excel Discussion (Misc queries) | |||
Calculate mean of test scores from rows of test answers | Excel Discussion (Misc queries) | |||
Test IF Two Numeric Values Match (from two separate Dynamic Ranges) | Excel Worksheet Functions | |||
test..where are my messages..test | New Users to Excel |