CountIf does not work with an Absolute references

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

countifs Function not giving desired result with date criteria 2
Countif and sumif combination problem 2
How to make an absolute reference to an excel 2007 table column 1
Excel Excel - Countif Not Working! It misses some cells. 1
SUMIF/COUNTIF with an additional criteria 1
At wits end dealing with "Assembly's manifest does not match assembly reference". Need help understa 3
Adding a row to worksheet does not update cell references in another. 5
How To Get 1 Million Visitors Without Paying A Dime In Advertising 2

Back
Top