Excel 2003 Formulas

[Open items]

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!!

[soybean]

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

How are you doing this? 

... 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?

[Open items]

No, I have no idea how to.  please help

[Open items]

i am usin the COUNTIF FORMULA

[soybean]

No, I have no idea how to.  please help

This Microsoft guide should help: Calculating subtotals and working with levels in Excel

[Open items]

No, 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 help

[soybean]

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. 

[Open items]

I sure thank you for your time.

[recovering disk space - old attachment deleted by admin]