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