The sum of cells in column C, if the column a and b are some values

Office

Question:I need to summarize the data in column C, if the column a and b contain certain values...Data below:A B CTeamLevelVacanciesJoe24Joe23Joe32Andrew43Andrew24Kelly11Sarah25The response must go in the below:That is, if the team Joe, and level 2 then count the number of vacancies in column c (the answer should be 7) Level12344 55TeamJoe Andrew Kelly SarahAnswer:With the teams in the column a from...Read More

Posted: 21 Feb 2012

Tags: The sum of cells in column C if the column a and b are some values The sum cells column the and are some values

Change the color of cell table based on the values in separate cell

Office

Question:If its like this:Pass, a pass B Col Col C D_______________________________Set the Score. Your results. 1_______________________________|Good. You marked 30 52. 2_____| |OK. | 3_____| |Poor. | 4_____|___________________________|Good has a green cell colorOK has a cell in yellow colourEvil has a red cell color** cell color styleWhere them "you have marked..." "columns are merged, the lines...Read More

Posted: 14 Feb 2012

Tags: Change the color of cell table based on the values in separate cell Change the color cell table based values separate

How to determine the values?

Office

Question:Example 1number in cell A1 is assigned to the-4.6I would like to retrieve 4 in 6 and cell B1 in cell C1.Example 2number in cell A1 is assigned to 12.86I would like to retrieve 12 in 8 and cell B1 in cell C1.Example 3number in cell A1 is assigned to the-32.975I would like to retrieve 32 9 and cell B1 in cell C1.Anyone have suggestions?Thanks in advance for suggestionsAnswer:C1= INT (ABS(A1...Read More

Posted: 27 Jan 2012

Tags: How to determine the values How determine the values

How to make a COUNTIF or an averageif when I need to check the values in two columns... for example, if the column has = "ABC" and column B > 0

Office

Question:How to make a COUNTIF or an averageif when I need to check the values in two columns... for example, "If a ="ABC"column and column b > 0" then count or average column b.I know I can do "= countif (B6..)"B50, "> 0") "..."But how to include the additional requirement of "A6"...A50, "= ABC WORK?";)Answer:HelloTo count= COUNTIFS(A6:A50,"ABC",B6:B50,">0")According to the average= AVERAGEIFS...Read More

Posted: 26 Jan 2012

Tags: How to make a COUNTIF or an averageif when I need to check the values in two columns for example if the column has ABC and column B gt 0 How make COUNTIF averageif when need check the values two columns for example column has ABC and

Addition of calculated totals that group / sort the values in a report footer.

Office

Question:I created a report which we use as a work order to produce products. I have included in the report footer calculated control which list the sum of the different elements necessary for the Assembly of products.A component varies depending on the size and color. I want that the total shown in the footer of this component together accordingly.I have 4 different colors and 6 different sizes of...Read More

Posted: 22 Jan 2012

Tags: Addition of calculated totals that group sort the values in a report footer Addition calculated totals that group sort the values report footer