| 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 vl
Thanks, I found what I was looking for in the EXCEL MISC Section. The count needed to be determined by a variable date range. I didn't need a VLOOKUP after all. "FSt1" wrote: hi really not sure what it is you are trying to count but see if this works for you =countif(B2:B1,"0") Regards FSt1 "BKP" wrote: 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? |
| Reply |
| 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 | |||
Hybrid Mode
