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(A4:D4)=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(A4:D4)=SUM(E1:E3),SUM(A4:D4),"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:D4)=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(A4:D4)=SUM(E1:E3),SUM(A4:D4)+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:D4)=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 |