| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
COUNTIF Formula
=COUNTIF(VLOOKUP(B2, SET,4,TRUE),1)
I am trying to use the above formula but it keeps coming back telling me there is an error with it. Bascially I want to count how many rows in "SET" are equal to 1 when a Column in "SET" is equal to the number in B2. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Countif formula | Excel Discussion (Misc queries) | |||
| COUNTIF FORMULA ISSUES - NEED FORMULA CORRECTED | Excel Worksheet Functions | |||
| CountIF and Sum in one formula? | Excel Worksheet Functions | |||
| CountIf formula results in the formula itself being displayed. | Excel Worksheet Functions | |||
| COUNTIF FORMULA | Excel Programming | |||
Threaded Mode
