Remember Me?

 topaz Posts: n/a XL formula - total of row = total of column

Have set up a very simplified worksheet to keep track of receipts

SAMPLE:
A B C D E
1 2.00 2.10 3.25 7.35
2 7.25 5.35 20.15 32.75
3 .50 1.29 1.79
4 9.75 5.35 3.39 23.40

I have been pretty lazy about formulas etc and have always managed to get
along with the most basic of formulas. But now I need to know how to create a
formula for cell 4E to total row 4 = to total column E & display value. For
example this is the formula I created =SUM(A4 4)=SUM(E1:E3) and it displays
a "TRUE" value in the cell but what I need is the sum of both the row & the
column to be displayed in the cell - and if it is not true then I need ot to
display "FALSE" in the cell

 Bob Phillips Posts: n/a =IF(SUM(A4 4)=SUM(E1:E3),SUM(A4 4),"FALSE")

--

HTH

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

"topaz" wrote in message
...
Have set up a very simplified worksheet to keep track of receipts

SAMPLE:
A B C D E
1 2.00 2.10 3.25 7.35
2 7.25 5.35 20.15 32.75
3 .50 1.29 1.79
4 9.75 5.35 3.39 23.40

I have been pretty lazy about formulas etc and have always managed to get
along with the most basic of formulas. But now I need to know how to

create a
formula for cell 4E to total row 4 = to total column E & display value.

For
example this is the formula I created =SUM(A4 4)=SUM(E1:E3) and it

displays
a "TRUE" value in the cell but what I need is the sum of both the row &

the
column to be displayed in the cell - and if it is not true then I need ot

to
display "FALSE" in the cell

 Steve R Posts: n/a Try
=if(SUM(A4 4)=SUM(E1:E3),SUM(A4 4)+SUM(E1:E3))

Steve

"topaz" wrote in message
...
Have set up a very simplified worksheet to keep track of receipts

SAMPLE:
A B C D E
1 2.00 2.10 3.25 7.35
2 7.25 5.35 20.15 32.75
3 .50 1.29 1.79
4 9.75 5.35 3.39 23.40

I have been pretty lazy about formulas etc and have always managed to get
along with the most basic of formulas. But now I need to know how to
create a
formula for cell 4E to total row 4 = to total column E & display value.
For
example this is the formula I created =SUM(A4 4)=SUM(E1:E3) and it
displays
a "TRUE" value in the cell but what I need is the sum of both the row &
the
column to be displayed in the cell - and if it is not true then I need ot
to
display "FALSE" in the cell

 Thread Tools Search this Thread Show Printable Version Search this Thread: Advanced Search Display Modes Linear Mode Switch to Hybrid Mode Switch to Threaded Mode Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On Similar Threads Thread Thread Starter Forum Replies Last Post Scott Excel Worksheet Functions 1 March 3rd 05 06:42 PM barney Excel Discussion (Misc queries) 3 February 13th 05 12:19 AM Coddie Excel Worksheet Functions 4 January 18th 05 02:31 PM Robin Smith Excel Discussion (Misc queries) 0 December 20th 04 08:47 PM havocdragon Excel Worksheet Functions 5 December 15th 04 10:03 PM

All times are GMT +1. The time now is 10:32 PM. Copyright ©2004-2020 ExcelBanter.