| Home |
| Search |
| Today's Posts |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Inconsistent Array Count results
This formula didn't work.
"Bob Phillips" wrote: Try =--('Other'!C9<"")+SUMPRODUCT(--('Other'!A16:A21,"MAR"),--('Other'!C16:C21) ) not an array formula -- HTH Bob Phillips (remove nothere from email address if mailing direct) "Suzanne" wrote in message ... In my CY 2005 timekeeping workbook I have a count function that works fine. In my identical CY 2006 workbook, the count function is not working fine. The result I'm trying to get is: 1. If Other!C9 has something in it, count it + 2. If cells in Other!A16:A21 = "MAR" count instances of entries in range C16:C21 {=(COUNT('Other'!C9))+(IF('Other'!A16:A21="MAR",CO UNT('Other'!C16:C21)))} I've checked formatting on both sheets ('Other' and the sheet with the formula) -- everything is identical from one book to the next. And no, I can't copy the working worksheet over. These worksheets contain inspection dates for numerous facilities and the number I'm trying to get is if more than one inspection was conducted during a given month (in this case, March). |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Return Array with Array | Excel Worksheet Functions | |||
| customise array formula output | Excel Discussion (Misc queries) | |||
| Count Intervals of 2 Numeric values in same Row and Return Count across Row | Excel Worksheet Functions | |||
| How can you use count with an array formula similar to using sum | Excel Worksheet Functions | |||
| VBA Import of text file & Array parsing of that data | Excel Discussion (Misc queries) | |||
Threaded Mode
