ExcelBanter - CountIf does not work with an Absolute references

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

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - CountIf does not work with an Absolute references (https://www.excelbanter.com/excel-discussion-misc-queries/164706-countif-does-not-work-absolute-references.html)

CountIf does not work with an Absolute references

Where is my error?

A B C Bonus to pay
Salesperson Invoice Target
Buchanan 15,000 14,000
=COUNTIF(B2:B7,"C2")*150.00
Buchanan 9,000
Suyama 8,000
Suyama 20,000
Buchanan 5,000
Dodsworth 22,500

JE McGimpsey

CountIf does not work with an Absolute references

Try
=COUNTIF(B2:B7,"" & C2) * 150

In article ,
GG wrote:

Where is my error?

A B C Bonus to pay
Salesperson Invoice Target
Buchanan 15,000 14,000
=COUNTIF(B2:B7,"C2")*150.00
Buchanan 9,000
Suyama 8,000
Suyama 20,000
Buchanan 5,000
Dodsworth 22,500

CountIf does not work with an Absolute references

Thanks!
This is what I needed.

"JE McGimpsey" wrote:

Try
=COUNTIF(B2:B7,"" & C2) * 150

In article ,
GG wrote:

Where is my error?

A B C Bonus to pay
Salesperson Invoice Target
Buchanan 15,000 14,000
=COUNTIF(B2:B7,"C2")*150.00
Buchanan 9,000
Suyama 8,000
Suyama 20,000
Buchanan 5,000
Dodsworth 22,500

All times are GMT +1. The time now is 07:22 AM.