| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
problem with array formula
It has been years since I've done an array formula. And I was never that
good with them. I would think that this should work: {=SUM((LEFT(A1:A35000,3)<"HD:")*(C1:C35000))} It doesn't. It gets #VALUE! Don. www.donwiss.com (e-mail link at home page bottom). |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Problem with a Array formula, Please help !! | Excel Worksheet Functions | |||
| Problem w/Array Formula | Excel Worksheet Functions | |||
| Array Formula Problem | Excel Worksheet Functions | |||
| problem with Array Formula | Excel Worksheet Functions | |||
| formula array problem | Excel Programming | |||
Threaded Mode
