help with arrray formula
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
|