question about excel?

Question

I have a table with data and the question is:
• The number of sales above the $ 70,000 from all the stores and months given
Which formula do i have to use for this?
How exactly do I type the formula in?

Answer 1

I am assuming you only wish to view the data in the cells which meet your criteria.



Open the spreadsheet in Excel

Select the Data menu

Select the Filter submenu and click the AutoFilter option

All the fields in the spreadsheet will display a dropdown arrow

In the Sales field dropdown menu click Custom

The Custom AutoFilter dialog box will appear

Select the "is greater than" option from the operator dropdown menu

Select or type the value you wish to use in the criteria box

Click the OK button



The spreadsheet will display only the records you want. You can then copy and paste the results to another sheet if you wish.



Note: to restore the original sheet do the following

Select the Data menu

Select the Filter submenu and click the AutoFilter option removing the check mark

The sheet will restore to the original view

Answer 2

If I understand your question correctly, you need to know in a given list, how many sales were more than 70,000. I would create a formula on the right of each line that determines if that months sales were more than 70,000. I am assuming that the total sales in each line are on column G - "=if(ga>70000, 1, 0)"



That will put a 1 in that cell if the sale was more than 70000. At the bottom of the list, count how many 1's you have and that will be your total number of sales greater than 70000.



If I made the wrong assumptions, please update the question.

Answer 3

This will happen if the cell is formatted for dates before you enter the value. Trying to change the format while there is a value in the cell will not help, since a different internal value is already being used by Excel. (Some people write their dates that way, so Excel obliges. Not sure how you got 42345, since the number 41078 is how Excel internally represents the date June 18 2012.) The cell has to be in General or Number format *before* entering the number you want.

Answer 4

I need a little more info. Are you using a access database? Are you trying to use the info from the database in excel? Also if so. Do you want to find all fields with sales greater than $70,000? Are the stores and months given in fields of the database? And lastly is that the names of the fields?

Answer 5

By using the conditional logic greater than...to research more for your homework go to the Mr.Excel website for instructions on how to apply the formula. Here is the link:



http://www.mrexcel.com/archive/Dates/5045.html



Here is one more resource for learning conditionals in Excel:



http://www.homeandlearn.co.uk/me/mes7p1.html

Answer 6

=COUNTIF(A2:A100,">70000")



So you've got the CountIf Function Countif(Range,Criteria) Works great