Home 
Search 
Today's Posts 
#1




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




=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




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 
Display Modes  


Similar Threads  
Thread  Forum  
Excel formula needed to amounts into one column pulling from 2 col  Excel Worksheet Functions  
How do I add a column to a sum formula for every row ie row 1 nee.  Excel Discussion (Misc queries)  
How do you copy a cell formula down a column without displaying n.  Excel Worksheet Functions  
ADDING SUM TOTAL OF MORE THAN 30 CELLS IN A COLUMN TOGETHER  WON.  Excel Discussion (Misc queries)  
I need a formula that will sum the top 3 number in a column  Excel Worksheet Functions 