| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
