Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old March 17th 05, 09:01 PM
topaz
 
Posts: n/a
Default 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(A44)=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

  #2   Report Post  
Old March 17th 05, 09:19 PM
Bob Phillips
 
Posts: n/a
Default

=IF(SUM(A44)=SUM(E1:E3),SUM(A44),"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(A44)=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



  #3   Report Post  
Old March 17th 05, 10:04 PM
Steve R
 
Posts: n/a
Default

Try
=if(SUM(A44)=SUM(E1:E3),SUM(A44)+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(A44)=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





Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel formula needed to amounts into one column pulling from 2 col Scott Excel Worksheet Functions 1 March 3rd 05 06:42 PM
How do I add a column to a sum formula for every row ie row 1 nee. barney Excel Discussion (Misc queries) 3 February 13th 05 12:19 AM
How do you copy a cell formula down a column without displaying n. Coddie Excel Worksheet Functions 4 January 18th 05 02:31 PM
ADDING SUM TOTAL OF MORE THAN 30 CELLS IN A COLUMN TOGETHER - WON. Robin Smith Excel Discussion (Misc queries) 0 December 20th 04 08:47 PM
I need a formula that will sum the top 3 number in a column havocdragon Excel Worksheet Functions 5 December 15th 04 10:03 PM


All times are GMT +1. The time now is 07:02 PM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017