ExcelBanter - Problem with sumproduct, countif functions..

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Problem with sumproduct, countif functions.. (https://www.excelbanter.com/excel-worksheet-functions/190100-problem-sumproduct-countif-functions.html)

Clay

Problem with sumproduct, countif functions..

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!

bpeltzer

Problem with sumproduct, countif functions..

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

Clay

Problem with sumproduct, countif functions..

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!

All times are GMT +1. The time now is 10:04 PM.