Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
can someone help me out with an array formula again?
range e4:e56 will contain a number most of the time this number can be appended with an x. over in column g there will be an amount. the x will always be the last character 1234 1000 5678x 500 135 200 i need a formula to sum column g4:g56 based on each condition, each in a separate cell. one result = 1200. the other = 500 can somebody help? -- Gary |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
looking up multiple values in an arrray | Excel Worksheet Functions | |||
{SUM(IF((ARRRAY FORMULA)} | Excel Worksheet Functions | |||
Set a 2D arrray data into a range, given the top-left cell | Excel Discussion (Misc queries) | |||
Commenting custom formula fields/formula on formula editor | Excel Programming |