| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cell formula, picking Text
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Cell formula, picking Text
This array formulae works for me even if the reference
(A12) is text (Using Excel XP) =SUM(IF(Sheet1!$A$9:$A$20=$A12,Sheet1!$B$9:$B$20,0 )) Abdul Salam -----Original Message----- 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 . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| 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) | |||
Linear Mode
