| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Absolute References | Excel Discussion (Misc queries) | |||
| Absolute References | Excel Worksheet Functions | |||
| Help with absolute references in a macro | Excel Discussion (Misc queries) | |||
| replace absolute references | Excel Worksheet Functions | |||
| replace absolute references | Excel Worksheet Functions | |||
Linear Mode
