=SUMPRODUCT((A1:A5="Bus Jet OEM")*(INT(B1:B5)=1))
This will count 1.1 thru 1.9
"Kell2604" wrote:

Hi Again,

I think I got it working by using B1:B50.

Thanks Again - you guys are the best!

"Mike" wrote:

=SUMPRODUCT((A1:A5="Bus Jet OEM")*(B1:B5=1))

"Kell2604" wrote:

Hello -
I think I need the COUNTIF function for this but am not getting it to work.
Help!
I need to count a range of cells, if the cell next to it contains a certain
value.

Comm Spares
Military OEM
Bus Jet OEM 1
Bus Jet OEM 1
Bus Jet OEM 1
Bus Jet OEM
Comm Spares
Comm Spares 1

So, I want the cell containing my formula to count the 1's if the cell to
it's left = Bus Jet OEM. I will have another cell counting the 1's if the
cell to it's left = Comm Spares and so on.
Hope my explanation makes sense.

Thanks in advance for your help!!
Kelley