Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have a formula that I usually use for picking numbers,
but it`s not working when I try to pick text. Isn`t the array formula useful for picking up text? {=SUM(IF(ABKunder!$B$9:$B$910=$F2;ABKunder! $D$9:$D$910;0);0)} Does anyone have a clue here. Help is appreciated Gunnar |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Picking up the latest text value in a column | Excel Worksheet Functions | |||
picking out a specific cell in a row | Excel Discussion (Misc queries) | |||
Picking up part of a formula from another cell | Excel Worksheet Functions | |||
Picking figures out of a cell | Excel Discussion (Misc queries) | |||
Picking a cell to show in another page. | Excel Discussion (Misc queries) |