Here it is with a sumproduct formula. A little easier than an array formula
(in my opinion)

=SUMPRODUCT((RIGHT(TRIM(E4:E56), 1)="x")*G4:G56)

and

=SUMPRODUCT((RIGHT(TRIM(E4:E56), 1)<"x")*G4:G56)

You don't need to use Ctrl + Alt + Enter to use these formulas.

--
HTH...

Jim Thomlinson


"Gary Keramidas" wrote:

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