| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
need formula to count non-zero items in an array based on a vlooku
I would like to count the number of #'s 0 from B$2:cell(vlookup(A1,A2:B7,2)
A B 1 Sep-4 2 Sep-1 10 3 Sep-2 0 4 Sep-3 5 Sep-4 5 6 Sep-5 12 7 Sep-6 The cell/vlookup combo doesn't seem to work. Any suggestions? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Array - Count based on 3 conditions | Excel Discussion (Misc queries) | |||
| How can I use and indexed value as the name of an array for vlooku | Excel Worksheet Functions | |||
| How to Count the number of "rows" (or Array items) included in a Sumif formula? | Excel Discussion (Misc queries) | |||
| How do I count items based upon two separate values? | Excel Worksheet Functions | |||
| 2 conditions needed to check and count of items based on that | Excel Worksheet Functions | |||
Threaded Mode
