adding values when mulitple criteria

Hi there!

Hope you can help me with this one!

I have company names in column E.
I have "contracted" in column I
I have "enrolled" in column J

How do I add the number of instances of "Contracted" and "Enrolled" for each of the companies showing in column E?

Thanks a ton!

Bruno

It will surely help if you attach a sample workbook.

Originally Posted by Richard Buttrey

Hi,

It would help too if you would update your details so that we know which version of Excel you have. e.g. only 2003, or 2007/2010 - or Mac perhaps.

It's possible that for your particular request you might get an answer which would work only with 2007 --> but not in 2003.

Regards

I have cleaned up the sheet a bit. Column A shows the companies, B shows whether contracted or not and C shows whether In Class or not, How do I calculate the total of Contracted and In Class for each of these companies. See attached (I use Excel 2007)

Originally Posted by Marcol

See if this workbook using dynamic named ranges and an unique values formula helps.

Select from the dropdowns in "Sheet2" B1 & C1

Add to "Sheet1" Column A as required, just keep the list continuous, i.e. no blanks.

Sorry but this is too complex for me! Any other solution you could offer?

Before we go forward, does it give you the results you need?

Originally Posted by Marcol

Before we go forward, does it give you the results you need?

Unfortunately not. I cannot figure out how to transpose the formula you gave me into the sheet. I tried to understand the contents of the formula to adapt it to what I need but I cannot figure it out.

Would you have anything simpler (for my brain)?

If your real data has the same layout as your sample, try pasting your data into Sheet1 of the file I posted make sure that the headers in Columns A:C match.

Then in Sheet2
Select Cells A10:C10 and use the Fill Handle to drag the formulae down until Column A returns a blank cell.

If this doesn't return the results you are expecting, then post a more representative sample of your workbook, showing before and after results so we can see where we are going.