| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Why wont this simple formula work
OK,nothing fancy here,but for some reason this wont work,I have a column A of appx 67 movies I want to buy,next column B I have a # 1 if I own it,and a # 0,if I dont,now below column b I have the simple formula =SUM(B91-(B1:B90)) B91 being the total # of movies I want which is 67, and of course adding B1:b90 equals # movies I already got..........once I type in the formula and hit enter it doesnt give me a total it gives a #VALUE! line,so I changed B91 to the number 67, =SUM(67-(B1:B90)) , and got the same #VALUE! total,I know Im going to feel stupid once I here what Im doing wrong but for some reason I cant get it right,what am I doing wrong Thanks Steve -- Bigredno8 ------------------------------------------------------------------------ Bigredno8's Profile: http://www.excelforum.com/member.php...o&userid=17162 View this thread: http://www.excelforum.com/showthread...hreadid=491215 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Match then lookup | Excel Worksheet Functions | |||
| A search for $ in a formula use to work now it does not work | Excel Discussion (Misc queries) | |||
| Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
| IF / VLOOKUP formula won't work until saved | Excel Worksheet Functions | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
Threaded Mode
