Formula for adding multiple manufacturers up

Is there a generic formula I can use to add up the number of quotes by manufacturer? What makes this complicated is some quotes may have multiple manufacturers within the same quote?

So for example, Quote 1 might have Siemens, Ericsson or Nortel. Others might only have Siemens.

The one I was going to use was SUMIFS($F$1:$F$5,000, "Ericsson") and so on for the different manufacturers, but what if that quote has multiple manufacturers parts within it, how can this be tabulated please?

Many thanks,

A sample file would help.

As you can see, there are a number of formulas to add up the number of different areas.
Instead of using the filters and then counting certain aspects of this file, is there a formula to be put into a table that will add up -
The different number of companies that are quoted.
The total number of quotes that relate to manufacture type. (Bearing in mind some of these quotes may have more than one manufacture type within the same quote, so would it be calculated if the quote was displayed into the cell as Siemens/Ericsson/Nortel)
The total number from the different sources. (So I can calculate over the first quarter how many quotes were Direct, how many were from PS, how many were from BB)

Many thanks,

Hi John, is this sample file enough to work from?

Hi Tommo,

Based on the example workbook you provided, you need to use the COUNTIF formula, instead of the SUMIF. SUMIF works with numbers, where COUNTIF will work with text.

In regards to multiple manufactures, would they both be listed in column F:F? e.g. | Ericsson, Siemens |

Hi, yes, they would all be listed in Column F if possible.
I think I worked it our for the BB, PS and Direct part, but has become a little longwinded and am sure there is a quicker way of doing this. (I've done it so I know the totals per quarter, i.e. Jan - Mar, Apr - June, July - Sept, Oct - Dec)
=COUNTIFS($A$16:$A$278, "*.01.2015", $E$16:$A$278, "BB") because the quotes for January are only up to row 278.
I just wanted to know if it was possible that if there was a multiple manufacture quote, if the manufacture could be put into one cell but the count would distinguish between the manufacturers? Many thanks,

Hey Tommo, would they always be listed in the same order? Like Ericsson first, Siemiens second, ect?

Unfortunately not necessarily, because I think it would be difficult for me to remember which order they need to be input if there are more than 4-5 manufacturers. not sure of the best solution to be honest. Thanks for your help so far. Hope we find a solution.