Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
=SUM(D50:V50)=SUM(W4:W49) - this is my actual formula
I have made worksheet to keep track & total receipts Example A B C D E 1 3 1 2 1 7 2 1 1 2 3 2 7 9 4 4 3 3 8 in the very last cell W50 (sample cell E4) I want the total of all the columns to equal the total of all the rows. The formula I created only puts "TRUE" in the cell but I need the actual value put in the cell and if it doesn't equal each other than it can put "FALSE" in the cell |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
IF & VLOOKUP FORMULA | Excel Worksheet Functions | |||
Problem with VBA returning the contents of a long formula. | Excel Discussion (Misc queries) | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) | |||
Help with macro formula and variable | Excel Worksheet Functions | |||
Cell doesn't show formula result - it shows formula (CTRL + ' doe. | Excel Worksheet Functions |