I am working on a project for work in where I need to create a sales calculator using excel. In this document basically yes=1 and no=0. I do not know how to give yes and no values. I then need to add all the values together and based on what that number is I need to choose one of the three package solutions we offer. Can anyone help???

If I get you right, what you need to do is put the item or parameter (for instance, the customer/prospect) in the first column (e.g. Cell A2), and put the Y/N (Yes/No) response in the second column against each (e.g. Cell B2).  Then there are two ways to sum up the Yes/No responses: (A) Put a third column and enter this formula against each (e.g. Cell C2) '=IF(B2="Y",1,0)' remember to include the Y within the double quotes ("Y").  Now copy this formula to all the cells below against which Y/N is there in the previous column - this should assign value 1 to all Ys and value 0 to all Ns.  Finally, at the end of this new (third) column, use the auto sum function (or simply type '=sum(C2:C4)' where C2 & C4 should be replaced with the first & last value cells (containing 1 or 0) - this should give you the total of all 1s (which stand for all Ys or 'Yes's).

OR (a simpler method) (B) Don't create the third column.  Click in the cell just below the last cell containing the Y or N.  Then enter the formula '=COUNTIF(B2:B4,"Y")' where B2 & B4 stand for the first and last cells where the Y/N responses are there.  This should give you the final result just like the earlier procedure, that is, the total of all Ys.  I've uploaded a simple worksheet to my Office Live workspace, in case you need to see.

Going beyond, you can even automate the last step of chosing one of the three packaged solutions based on the sum as above - with just a couple of steps more.

Sure.  First you've to list out the three options someplace, for instance, Cells F1, F2 & F3, perhaps indicating that you want to choose the package named at Cell F1 (whatever it is) if the sum derived out of the previous steps (total of Ys) is more than 6, the package at Cell F2 if it is between 3 to 5, and package at Cell F3 if it's less than 3.

Now, at any place (preferably in the cell below where the total of Ys appears e.g. B6), enter this formula: '=IF(B5>5,F1,IF(B5>2,F2,F3))', where B5 stands for the cell containing the sum of Ys.  This should automate the choosing of the options.

Thinking about it, perhaps you can even dispense with the first step above of listing out the options/packaged solutions, and instead put the options within the formula itself, like this: '=IF(B5>5,"Option C",IF(B5>2,"Option B","Option A")), of course replacing the options within quotes with the actual description you want to put.

 Happy 'Excel'ling!