Solve : Excel 2003 Formulas?

1.	Solve : Excel 2003 Formulas?
Answer» I have a rolling completion list entered into excel. There are many columns in this worksheet. Two specific columns I am trying to calculate are the responsilbe company column and the "Open" "Closed" column. I have been able to formulate how many total items each contractor has, but have not been able to define which items are open and which items are closed within each contractor total. HELP!!Quote from: Open items on November 23, 2010, 09:41:10 AM I have been able to formulate how many total items each contractor has ... How are you doing this? Quote from: Open items on November 23, 2010, 09:41:10 AM ... but have not been able to define which items are open and which items are closed within each contractor total. Have you tried the Sub-totals FUNCTION? No, I have no idea how to. please helpi am usin the COUNTIF FORMULAQuote from: Open items on November 23, 2010, 10:04:00 AM No, I have no idea how to. please help This Microsoft guide should help: Calculating subtotals and working with levels in ExcelNo, this does not seem to work. I used the COUNTIF to calculate how many items are assigned to an individual contractor. For example LONG Flooring has 5 items assigned to them. All items are opened but 1, what formula can I use to determine by number and value which items are opened and which items are closed. I have worked the totals to the side of my worksheet, that being said I need to be able to put a formula into the cell I want the information to show. All contractors are in one column and "Open" and "Closed" are in one column TOGETHER. Please helpQuote No, this does not seem to work. I suspect that's because you're not familiar with it and you are not using it the right way. Anyway, here's another suggestion. Try using AutoFilter (from the main menu, Data, Filter, AutoFilter. A reference: http://www.excelfunctions.net/ExcelFilter.html If you can create a spreadsheet with the same layout as yours, using fictitious data, and attach it to a forum post, I'll take a look later (will be away from computer for some hours; may be TONIGHT before I'll be back). To attach a file to a forum post, click on Additional Options... at the bottom of the forum message composition panel and click the Browse button at the right of the box under Attach. I sure thank you for your time. [recovering disk space - old attachment deleted by admin]

Answer»

I have a rolling completion list entered into excel. There are many columns in this worksheet. Two specific columns I am trying to calculate are the responsilbe company column and the "Open" "Closed" column. I have been able to formulate how many total items each contractor has, but have not been able to define which items are open and which items are closed within each contractor total. HELP!!Quote from: Open items on November 23, 2010, 09:41:10 AM

I have been able to formulate how many total items each contractor has ...

How are you doing this?

Quote from: Open items on November 23, 2010, 09:41:10 AM

... but have not been able to define which items are open and which items are closed within each contractor total.

Have you tried the Sub-totals FUNCTION? No, I have no idea how to. please helpi am usin the COUNTIF FORMULAQuote from: Open items on November 23, 2010, 10:04:00 AM

No, I have no idea how to. please help

This Microsoft guide should help: Calculating subtotals and working with levels in ExcelNo, this does not seem to work. I used the COUNTIF to calculate how many items are assigned to an individual contractor. For example LONG Flooring has 5 items assigned to them. All items are opened but 1, what formula can I use to determine by number and value which items are opened and which items are closed. I have worked the totals to the side of my worksheet, that being said I need to be able to put a formula into the cell I want the information to show. All contractors are in one column and "Open" and "Closed" are in one column TOGETHER. Please helpQuote

No, this does not seem to work.

I suspect that's because you're not familiar with it and you are not using it the right way. Anyway, here's another suggestion. Try using AutoFilter (from the main menu, Data, Filter, AutoFilter. A reference: http://www.excelfunctions.net/ExcelFilter.html

If you can create a spreadsheet with the same layout as yours, using fictitious data, and attach it to a forum post, I'll take a look later (will be away from computer for some hours; may be TONIGHT before I'll be back). To attach a file to a forum post, click on Additional Options... at the bottom of the forum message composition panel and click the Browse button at the right of the box under Attach. I sure thank you for your time.

[recovering disk space - old attachment deleted by admin]

Solve : Excel 2003 Formulas?

Discussion

No Comment Found

Related InterviewSolutions

Reply to Comment