Count only numeric codes

[ecabanas]

Hi all,

I have the salesline table, where I have all my sales. there I have itemid and quantity.

I would like to make a Sum from all the quantities but only from the itemid numeric.

ITEMID     QTY

11111         1

12SSS          4

22222          3

The formula should result: 4

Could somebody help to me?

=num(Sum({<[ITEMID]={'A-Z'}>} QTY),'#.###,')

thank's

Eduard

[swuehl · Accepted solution]

Maybe

=sum( if (isnum(ITEMID), QTY))

[ecabanas]

it works!!!! thank's

Eduard