| Home |
| Search |
| Today's Posts |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
COUNTIF function bug?
=SUMPRODUCT(--(LEFT(H2:H1062;2)="17*"))
Don't use the wildcard! =SUMPRODUCT(--(LEFT(H2:H1062;2)="17")) Biff "raigo" wrote in message ... Thank you all for your replies, unfortunately i still cant get it to work :( It gives me a zero on all of these 3 options. For example: =SUMPRODUCT(--(LEFT(H2:H1062;2)="17*")) gives a zero. I had to replace "," with ";" as the formula was incorrect if there was "," Any more ideas? Thank You |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Custom functions calculating time arguments Help Desperate | Excel Worksheet Functions | |||
| CountIf Function Question | Excel Discussion (Misc queries) | |||
| CountIF Function On Linked Spreadsheet | Excel Discussion (Misc queries) | |||
| can you use countif function for noncontiguous cells | Excel Worksheet Functions | |||
| Excel option to store trendline's coefficients in cells for use | Charts and Charting in Excel | |||
Threaded Mode
