I'm doing a spreadsheet showing the amount of Lease, Finance, and Cash deals
each Finance Manager has seen. Each Finance Manager is represented by a
number.

So I need the formula to display the number of times "Lease" is displayed in
C7:C100, but for each individual F&I manager.

I tried..
=SUMPRODUCT(--(A7:A102=1),COUNTIF(C7:C102,"Finance"))
Where the 1 represents a certain F&I Manager. I knew it was wrong, but I'm
lost.. #VALUE! comes up right now.

Thanks for your help in advance. And extra thanks for anyone who helped
with my question earlier today!

=SUMPRODUCT(--(A7:A102=1),--(C7:C102="Finance"))

"Clay" wrote:

I'm doing a spreadsheet showing the amount of Lease, Finance, and Cash deals
each Finance Manager has seen. Each Finance Manager is represented by a
number.

So I need the formula to display the number of times "Lease" is displayed in
C7:C100, but for each individual F&I manager.

I tried..
=SUMPRODUCT(--(A7:A102=1),COUNTIF(C7:C102,"Finance"))
Where the 1 represents a certain F&I Manager. I knew it was wrong, but I'm
lost.. #VALUE! comes up right now.

Thanks for your help in advance. And extra thanks for anyone who helped
with my question earlier today!

Ahh thanks! I thought I had tried that but must have messed up somewhere..
Thanks a lot :)

"bpeltzer" wrote:

=SUMPRODUCT(--(A7:A102=1),--(C7:C102="Finance"))

"Clay" wrote:

I'm doing a spreadsheet showing the amount of Lease, Finance, and Cash deals
each Finance Manager has seen. Each Finance Manager is represented by a
number.

So I need the formula to display the number of times "Lease" is displayed in
C7:C100, but for each individual F&I manager.

I tried..
=SUMPRODUCT(--(A7:A102=1),COUNTIF(C7:C102,"Finance"))
Where the 1 represents a certain F&I Manager. I knew it was wrong, but I'm
lost.. #VALUE! comes up right now.

Thanks for your help in advance. And extra thanks for anyone who helped
with my question earlier today!