Need formula help
 

=SUM(D50:V50)=SUM(W4:W49) - this is my actual formula

I have made worksheet to keep track & total receipts
Example
A B C D E
1 3 1 2 1 7
2 1 1 2
3 2 7 9
4 4 3 3 8

in the very last cell W50 (sample cell E4) I want the total of all the
columns to equal the total of all the rows. The formula I created only puts
"TRUE" in the cell but I need the actual value put in the cell and if it
doesn't equal each other than it can put "FALSE" in the cell

I would think it would have to be an IF statement of some kind

Maybe =IF(SUM(D50:V50)=SUM(W4:W49)), SUM(cells), FALSE)

Something to that effect?


"topaz" wrote in message
...
=SUM(D50:V50)=SUM(W4:W49) - this is my actual formula

I have made worksheet to keep track & total receipts
Example
A B C D E
1 3 1 2 1 7
2 1 1 2
3 2 7 9
4 4 3 3 8

in the very last cell W50 (sample cell E4) I want the total of all the
columns to equal the total of all the rows. The formula I created only
puts
"TRUE" in the cell but I need the actual value put in the cell and if it
doesn't equal each other than it can put "FALSE" in the cell

See my reply in previous question.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"topaz" wrote in message
...
=SUM(D50:V50)=SUM(W4:W49) - this is my actual formula

I have made worksheet to keep track & total receipts
Example
A B C D E
1 3 1 2 1 7
2 1 1 2
3 2 7 9
4 4 3 3 8

in the very last cell W50 (sample cell E4) I want the total of all the
columns to equal the total of all the rows. The formula I created only
puts
"TRUE" in the cell but I need the actual value put in the cell and if it
doesn't equal each other than it can put "FALSE" in the cell

This works. Add your own cell paramters:

=IF(SUM(A1:D2)=SUM(A3:C3),SUM(A1:D2),"FALSE")


"topaz" wrote in message
...
=SUM(D50:V50)=SUM(W4:W49) - this is my actual formula

I have made worksheet to keep track & total receipts
Example
A B C D E
1 3 1 2 1 7
2 1 1 2
3 2 7 9
4 4 3 3 8

in the very last cell W50 (sample cell E4) I want the total of all the
columns to equal the total of all the rows. The formula I created only
puts
"TRUE" in the cell but I need the actual value put in the cell and if it
doesn't equal each other than it can put "FALSE" in the cell

=(SUM(D50:V50)=SUM(W4:W49))*SUM(D50:V50)

which delivers either an actual sum or 0, the latter signifying an error.

topaz wrote:
=SUM(D50:V50)=SUM(W4:W49) - this is my actual formula

I have made worksheet to keep track & total receipts
Example
A B C D E
1 3 1 2 1 7
2 1 1 2
3 2 7 9
4 4 3 3 8

in the very last cell W50 (sample cell E4) I want the total of all the
columns to equal the total of all the rows. The formula I created only puts
"TRUE" in the cell but I need the actual value put in the cell and if it
doesn't equal each other than it can put "FALSE" in the cell