| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
wild card in sumproduct
Hi
Trying to count two crieria using sumproduct. First criteria is in A3, the second criteria on the indirect sheet is L/R UK, or L/R 104 Minor Uk, or L/R Spain. or L/R Major Mkts. I want to count all of these, but not Landrover - ferry, so thought the wild card would be the way forward. I am using =sumproduct((indirect(""&F1&"!B1:B2000")=A3)*(indi rect(""&F1&"!F1: F2000="L/R************))-E3 am getting ref# Is this the best way forward (wild card) and any idea's why it doesnt work Help appriciated Regards Brian -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...tions/200711/1 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| sumproduct with a search and wild card | Excel Discussion (Misc queries) | |||
| Wild Card Search | Excel Worksheet Functions | |||
| wild card -- help with formula | Excel Discussion (Misc queries) | |||
| Wild card * | Excel Worksheet Functions | |||
| Wild Card and Dates | Excel Worksheet Functions | |||
Threaded Mode
