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

Why wont this simple formula work
 

I think that what you intended with your formula was:

=B91-SUM(B1:B90)


--
HTH

Sandy

Replace@mailinator with @tiscali.co.uk


"Bigredno8" wrote
in message ...

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

Why wont this simple formula work
 

Thanks,that was it,pure & simple

Steve


--
Bigredno8
------------------------------------------------------------------------
Bigredno8's Profile: http://www.excelforum.com/member.php...o&userid=17162
View this thread: http://www.excelforum.com/showthread...hreadid=491215

Why wont this simple formula work
 

=SUM(B91-(B1:B90))

Hi. Just to mention. If you had entered the equation with
Ctrl+Shift+Enter, then it would have worked:
=SUM(B91,-B1:B90)

--
Dana DeLouis
Win XP & Office 2003


"Bigredno8" wrote
in message ...

Thanks,that was it,pure & simple

Steve


--
Bigredno8