Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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 |